Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

date field with index cause error

Status
Not open for further replies.
yaya013

yaya013

Programmer
Jun 4, 2003
53
IL
Hello !!

I have an Access 97 application ,
when i run a querie with criteria on a date data type field , the Access display a fatal error and close.
Only when I define the field as non index the error disappear .
any idea ? ? ?

 
Status
Not open for further replies.

Similar threads

Swi
  • Question
Select X of each variation of a field 1
Replies
8
Views
393
rashmibala
R
C
  • Question
Run-time error '3075': Syntax error (missing operator) in query expression 'Birthday = and Birthmonth ='.
Replies
3
Views
218
OzFoxy
OzFoxy
BugZap13
  • Locked
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
542
mikrom
mikrom
datajockey123
  • Locked
  • Question
Note / Information box with date and time stamp for each entery
Replies
2
Views
764
dhookom
dhookom
monkeysee
  • Locked
  • Question
Max Date Qry 1
Replies
3
Views
830
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top