Do both Invoice Date fields contain just dates or does one or both contain Time as well
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
Hi Bob,
I actually just rebuilt my database (just started), and it works. sorry to waste your thought on this. Still not sure what happened.
Thank you,
Peter
No problem.
Would just like to advise you against using object names (tables, fields, reports etc) with spaces in them. For example, InvDate would be much better than Invoice Date. A;so, tables should almost always have a Primary Key field.
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick