Create Records

[Guest]

I am creating a tenant database and would like to create a query where I
charge each tenant monthly rent. I have a table that lists the tenant info
including the rent amount and a table that reflects each transaction linked
to the tenant table. How do I use a query (append?) to create a new
transaction for each tenant in the transaction table. I would also like to
fill the date field in the transaction table with a specified date such as
11/01/07 for all the new transactions.

Any help would be appreciated.

 

[Carl Rapson]

I am creating a tenant database and would like to create a query where I
charge each tenant monthly rent. I have a table that lists the tenant info
including the rent amount and a table that reflects each transaction
linked
to the tenant table. How do I use a query (append?) to create a new
transaction for each tenant in the transaction table. I would also like to
fill the date field in the transaction table with a specified date such as
11/01/07 for all the new transactions.

Any help would be appreciated.

Something like:

INSERT INTO [tenant transactions] ([transaction date],[tenant id])
SELECT "#11/01/2007#",[tenant id] FROM [tenants];

Carl Rapson