Generate report

[ankurmisra]

I am preety unfamiliar with reports.

I want to generate a report, when my table (generated from my form) has the following value:

Date Needed is after the Date Recieved.

I would like it to generate the day after the date needed while the date recieved field is still blank.

ex.
in my table the field Date needed has been filled to be August 1st and the Date Recieved is blank. If and When August 2nd hits and the Date Reciveved has still not been filled then the report is generated.

Thank you very much, I really appreciate your help!

 

[lupins46]

You need to select the records for your report in a query.

Select * from mytablename where
[Date Needed]>Date() and isnull([Date Received])

Then use this query as the source for your report.

 

[ankurmisra]

Thanks for the help Lupins but I can't figure it out. I put a comand button in my report in which I was going to put this query in the code builder on the event in the properites of this command button. however it doesnt seem to let me put code in the event tab as it is a blank tab??

 

[lupins46]

You need to create a new query (any query will do) and switch to SQL view using the drop down onm the first button.
Delete the sql that is already there and put the sql from my first post into this pane (make sure you fix the table and field names).You can then switch to design view or datasheet view.