I want to compare the date in one field in a table for different records. How to write the query?
S Sophia Jun 3, 2004 #1 I want to compare the date in one field in a table for different records. How to write the query?
A Allen Browne Jun 4, 2004 #2 See: ACC2000: Referring to a Field in the Previous Record or Next Record at: http://support.microsoft.com/default.aspx?scid=kb;en-us;210504&Product=acc2000 -- Allen Browne - Microsoft MVP. Perth, Western Australia. Reply to group, rather than allenbrowne at mvps dot org. Sophia said: I want to compare the date in one field in a table for different records. Click to expand... How to write the query?
See: ACC2000: Referring to a Field in the Previous Record or Next Record at: http://support.microsoft.com/default.aspx?scid=kb;en-us;210504&Product=acc2000 -- Allen Browne - Microsoft MVP. Perth, Western Australia. Reply to group, rather than allenbrowne at mvps dot org. Sophia said: I want to compare the date in one field in a table for different records. Click to expand... How to write the query?
