Date in a Report

[lansel]

I submitted the question under another topic and didn't get a response. I probably confused everyone including myself.

If a report has a text box with just the current date to be entered when the report is issued =date() . I am copying the information to a table, using an append query, with the date it was issued. I then created a query for a report (History Report) form the table that list the information with the date the original report was issued. The Date issued is showing up blank in my History Report. What am I doing wrong?

I have been reading through the forum for similar problems and I found one but it didn't have a response!

Thanks,

 

[Mark Wild]

Hi,

Just to check a few things.

Do you store two dates for the report? Ie date issued and original date issued?

Once you've run the append query, is all the data required stored in the tables correctly, in whcich case we're looking at a query problem, or is this a problem with the append query?

 

[lansel]

Thanks for responding!!

There is another date field in the report and it is working fine. It is a date where an employee missed time. It is entitled date and the date is entered.

No, the date is not being stored in the table. I think the problem is with the query.

 

[Mark Wild]

mmm...

Can you post a sample as there are too many potential things to list.