Data type mismatch in criteria expression

G

Guest

I've got a query that used to work. When I started working on it this
morning, it said that the program had been closed incorrectly and it needed
to try to repair itself.

Now I get the error message: "Data type mismatch in criteria expression".
I've tracked the "mismatch" back to some of my date/time expressions. This
used to work:
IIf(Weekday([start_date])<=5,DateAdd("d",(5-Weekday([start_date])),[start_date]),DateAdd("d",(12-Weekday([start_date])),[start_date]))

But now it doesn't. Any suggestions??
 
G

Guest

I have two guesses:

1. Database corruption:
Tony Toews has an excellent web page on database corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp

2: A references problem. Go to the following web page for information on
checking references:

http://www.mvps.org/access/bugs/bugs0001.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top