Please help. I have a database which has a report. The report has a query which needs to check that a field contains a date in a certain format. The date is written as the year, month, and day put together into one string. For example today would be written as 20010730. How can I use MS Access to get the values that are greater than the current date. Or even more simply how can I get the values of the current month, day, and year. I know this is a lot to ask for but any help would be appreciated.

Thanks in advance,
Calvin