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...
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
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.