Problem with date entry and sums

[melia05]

I'm brand new to access 07, I've entered a large amount of data into a template form I'm having trouble with the entry date field. It shows multiple ###### signs when I print in the report wizard, I've tried re-entering the record and saving it but it doesn't fix the problem. Also the transaction amount field sometimes will total and sometimes it won't. Please help!!!!

 

[Mike Vytal]

Melia, go to report design view and check open the properties window. Check the format of the date field. The only other thing I could suggest is to widen the control.

With the transaction total, I would suggest running a report that gives the total and one that doesn't then doing some analyzing to see if anything's different.