Append Query Problem!!

[headintheclouds]

Hi there hope you can help

I need an append query to add weekly rent records to the rents table (only properties that are currrently occupied) When the query is run it should promt the user to enter a week ending date and pick up the weekly rents from the proberty list table.

The tables are as follows:

tblRent (this is the table I need to append to)

Name Description

Tenant ID (Selected from the tenant table)
Date Due (the week ending date does in here)
Amount (this were the weekly rents goto for each
tenant and is selected from the proberty list
table)
Paid On (I will enter these dates manually)

tblOccupancy

Tenant Id (Selected from the tenant table)
End Date (If null then still occuiped)

tblProbertyList

Weekly Rent (These values must go into the [amount] of
the rents table)

I've attached the database and hope that you can help

Thanks

HeadintheClouds

 

[M8KWR]

could you convert the db to A97 for me please.

Quite a simple query really, it should not take me long.

 

[headintheclouds]

Hi mate sorry it has took so long been at work, anyway I have attached the database for access 97

Cheers

P.S you could have a look at this one to please

http://www.access-programmers.co.uk/forums/showthread.php?t=86015

Thanks again