Hi Guys
I have tried to figure this out but can't so I'm hoping I'm missing something easy that somebody will help me solve.
I have a query that basically chooses records from a table that contains a list of Invoices with a field, [InvoiceDate] based upon the following criteria:
Is Not Null And <Date()-1
This works well.
I have another table, "ConfigurationInformation" that has a single record that contains the various configuration and setup parameters for the the application.
It contains a field called [NumberOfDays].
I want to pass the contents of the [NumberOfDays] field the Date so that it looks something like the following:
Is Not Null And <Date()- [NumberOfDays]
I just can't figure it out.
Thanks for any help you can provide.
Cheers
Greg
I have tried to figure this out but can't so I'm hoping I'm missing something easy that somebody will help me solve.
I have a query that basically chooses records from a table that contains a list of Invoices with a field, [InvoiceDate] based upon the following criteria:
Is Not Null And <Date()-1
This works well.
I have another table, "ConfigurationInformation" that has a single record that contains the various configuration and setup parameters for the the application.
It contains a field called [NumberOfDays].
I want to pass the contents of the [NumberOfDays] field the Date so that it looks something like the following:
Is Not Null And <Date()- [NumberOfDays]
I just can't figure it out.
Thanks for any help you can provide.
Cheers
Greg