specifying Date criteria
From: David (David_at_discussions.microsoft.com)
Date: 08/26/04
- Next message: yaahee: "update query"
- Previous message: Stephen Rasey: "Re: Complex Subquery: ...FROM(TRANSFORM... systax - (fixed linebreaks)"
- Next in thread: David: "RE: specifying Date criteria"
- Reply: David: "RE: specifying Date criteria"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 25 Aug 2004 17:31:03 -0700
Hi,
I want to select records based on date which is a field that look like this:
xx/xx/xxxx.
I specified this as criteria in Design View: <"06/15/2003"
But it does'nt work.
Access does not recognize the field as a date.
Thanks for any help on this.
David
- Next message: yaahee: "update query"
- Previous message: Stephen Rasey: "Re: Complex Subquery: ...FROM(TRANSFORM... systax - (fixed linebreaks)"
- Next in thread: David: "RE: specifying Date criteria"
- Reply: David: "RE: specifying Date criteria"
- Messages sorted by: [ date ] [ thread ]