Hi All
I know this has probably been asked a heap of times before but I cannot find the solution.
What I would like to do is pretty simple.
I want to create a report that refers to a "ReviewDue" cell in a table and if the date has passed then add the expired documents to the report. If today > ReviewDue date then have those results filtered.
However I have not worked with dates in Access before and have no-idea where to start.
I was thinking of having a hidden control on a form that would have today's date in it (through calling the system date) and then using baldy's filter example however I am really new to access and have no-idea how to link this to the table syntax wise
this is what I thought would work but again I dont know about dates and it probably won't (am about to try the following but if it does not work then I have no-idea where to go, hence the pre-emptive post)
[/COLOR][/FONT]
Any help is appreciated
Rey
I know this has probably been asked a heap of times before but I cannot find the solution.
What I would like to do is pretty simple.
I want to create a report that refers to a "ReviewDue" cell in a table and if the date has passed then add the expired documents to the report. If today > ReviewDue date then have those results filtered.
However I have not worked with dates in Access before and have no-idea where to start.
I was thinking of having a hidden control on a form that would have today's date in it (through calling the system date) and then using baldy's filter example however I am really new to access and have no-idea how to link this to the table syntax wise
this is what I thought would work but again I dont know about dates and it probably won't (am about to try the following but if it does not work then I have no-idea where to go, hence the pre-emptive post)
Code:
[FONT=Courier New]DoCmd.OpenReport "expired",acViewPreview , , "ReviewDue < [COLOR=#ff0000]#[/COLOR]" & Me.Today[COLOR=#ff0000] & "#"[/COLOR][/FONT]
[FONT=Courier New][COLOR=#ff0000]
Any help is appreciated
Rey