I have to make some assumptions here...because I cant see the data.
If you were to do this:
Insert into current_month (long_fax)
select long_fax from
Long_Distance_Faxtbl where account='Current Month'
You would select all of the Long faxes from the Long_distance_faxtbl where the account = 'CURRENT MONTH'. It would then insert these long faxes figures into the current_month table in the long_fax category.
You can join tables too...
Insert into current_month (long_fax, col2, col3, col4)
Select l.long_fax, b.test_col, b.test_col2, b.test_col3
from long_distance l, fake_table b
where l.fax_id = b.fax_id
and l.account = 'CURRENT MONTH'
Ok some how on all of this I am lost. I have tried to in access take two tables, and based on basically the account is what joins the two tables, so I thought that maybe in the SQL window I could write something that access was not allowing me to do, but I'm not sure I understand what has been explained to me to help me do what I am trying to do.
In SQL I can query the two tables and from the current Month table I pull account and the Long distance record returns all blanks and in the same query I get from the Long distance table all the records with accounts and in the Long distance column I get 3.1.