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!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by burgess1975
-
Queries not opening in design view
Josh, Sounds like you might have some corruption in the DB file. I have a couple suggestions: 1) Have you tried to compact & repair the db? If yes, but that didn't work: 2) Make a new, blank DB and import all of the objects from your troubled db into it. Many times, a corrupt DB that can't...- burgess1975
- Post #3
- Forum: Microsoft: Access Other topics
-
Expression problem
Here's what you want: "Mailed-MD/DO": Sum(IIf([providers!degree]="MD" Or [providers!degree]="DO" And IsNull([credentials]![MailDate])=False,1,0)) In Access, use IsNull(Expression) instead of Expression Is Not Null. -Jeff Burgess- burgess1975
- Post #2
- Forum: Microsoft: Access Queries and JET SQL
-
Date comparison
Jack, SELECT Field1, Field2 FROM tblMyTable WHERE MyDateField BETWEEN #2002-15-02# AND #2002-04-07# will return all recs with MyDateField between February 15, 2002 and July 4, 2002. I recommend the ANSI format YYYY-MM-DD for dates when you can. HTH, Jeff Burgess- burgess1975
- Post #2
- Forum: Microsoft: Access Queries and JET SQL
-
Error when using DoCmd.Close
Are you doing this in an MDE or MDB? -Jeff Burgess- burgess1975
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
