B
Ben Avery
G'day
Lets say I have an access DB which has the following
columns:
Column 1 - Item List
Column 2 - Date Used List
Let's say that every 6 months each item from the Item List
must be used.
I can set up a query in which I have 2 columns taken from
the table above and where I can manually type in the date
from 6 months ago to work this out which would look
something like this:
<#11/02/2003#
When I hit "Run" I will get a list of every Item which has
NOT been used for the last 6 months but the annoying thing
is, I have to change the query every day!
How can I get around this with a simple expression?
BA
Lets say I have an access DB which has the following
columns:
Column 1 - Item List
Column 2 - Date Used List
Let's say that every 6 months each item from the Item List
must be used.
I can set up a query in which I have 2 columns taken from
the table above and where I can manually type in the date
from 6 months ago to work this out which would look
something like this:
<#11/02/2003#
When I hit "Run" I will get a list of every Item which has
NOT been used for the last 6 months but the annoying thing
is, I have to change the query every day!
How can I get around this with a simple expression?
BA