Hi, I am currently trying to get a query to only output data that was "added" to a table in the last three months.
I have produced the following, although it is a poor way of getting round the problem. Could someone help me create a more efficient query. E.g. so the database would automatically know the current date etc.
Any help would be greatly appreciated.
Thanks
I have produced the following, although it is a poor way of getting round the problem. Could someone help me create a more efficient query. E.g. so the database would automatically know the current date etc.
Code:
Between #01/09/2008# And #01/01/2009#
Any help would be greatly appreciated.
Thanks
