Installation Statement

[Fraudie]

I'm making a database for school.

Its a car mod shop and i have a button to search for all transactions by clients who chose installation as yes. (This is an added fee)

At the moment it shows all installations but i want to do a find for only the ones in the last week. I found a similar topic but it didnt help.

[Vaughan]

You'll need to have an "installation date" field.

[Fraudie]

Basically when a transaction is made, installation is chosen as yes or no for that product. So the transaction date can in a sense be the installation date. What i want the outcome to basically do is come up with all transactions in the last week where installation was chosen as yes. At the moment my find script just searches for all installations and i want to make it i suppose the todays date of the search and then - 7 days and up to todays date (of the find).