Query Question 1

J

JIT

I am getting an error report about data type mismatch in criterion
expression. Here it is:

IIf(DateDiff("d","Arrival Date",[Start Date])>CBool(Rates![Free
Days]),"Departure Date") Or IIf(DateDiff("d","ArrivalDate",[Start
Date])<CBool(Rates![Free Days]),(("Max Charge Days Total")-CBool((Rates![Free
Days])-(DateDiff("d","Arrival Date",[Start Date])))))

can you tell me what is wrong?
 
R

RBear3

You already asked this once and you were given a response. Please go view
that thread and reply to it.
 

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

Similar Threads

Query Question 1
Update SQL 1
SQL Mix up? 3
Query Trouble 1
Update Error 1
Date/Time Filter problem 5
date diff using criteria 3
Query Parameter 4

Top