rent due adding to transactions (1 Viewer)

[Jediphase]

Hey folks gurus and fellow programmers long time no post!

Nice new setup!

I need some help for a system which i am working on.

I want to be able to search a table with fields [property name] [rent due date] and [rent amount]

when the rent due date the current date i want it to take that record and post the relevant data into a transactions table.

How do i do that please? would it be a query to obtain the data then an apend ?? how do i do that?

Thanking you team chat soon (Hopefully) Mission I would like to see a contribution from yourself as well if possible please! No slacking!

J

 

[Donna Tunstall]

Jedi

Drop down the fields you need into your query grid, including [Rent Due Date]. As the criteria for [Rent Due Date] just enter =Date(), this will return all the records for which the Due Date matches today's date.

If you wanted a 'futures' report to look at, say, rents due in the next week you could use Between Date() and Date()+7
etc, etc
HTH

 

[Jediphase]

Yep that bit i have no problem with its the best way to go about taking that information from the query and then dropping it into a transaction table.