Update SQL

G

Guest

I am getting an error statement that I have a data mismatch in the criteria
expression. Can anyone tell me where it is?


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


thank you,

JIT
 
L

Lynn Trapp

I've already answered this in another newsgroup, but basically DateDiff
requires 2 dates as it's arguments, but you have one string ("Arrival Date")
and one Date ([Start Date]).
 

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

Update Error 1
SQL Mix up? 3
Query Question 1
Query Question 1 1
Expression help 1
Date Difference In Query 2
Query Trouble 1
Expression Error on Parameter Query with link to Cross Tab Query 8

Top