Disable enter parameter value

[LTDragon07]

I have a query in which I'm converting number date "20150415" to "15-Apr-15" and then find the difference between 2 dates. first and last dates
I'm using the following expressions;
FLabour is a group by "Min" which is searching a Linked ODBC table.

Fdate: IIf(Len([FLabour])=8,CDate(Mid([FLabour],5,2) & "/" & Right([FLabour],2) & "/" & Left([FLabour],4)))
which converts"20150415" to "15-Apr-15"

TotalDays: DateDiff("d",[Fdate],[Ldate])


The problem I'm running into, is that some of the fields in [FLabour] are blank and the enter parameter value box comes up. Is there a way to skip this entry as I will never what to enter a value.

 

[mole999]

maybe test that the field has numeric values before running the statement

 

[Tubal]

Total Days may be one less than you expect. If the first date is the same as the last date you will get 0. Do you expect 0 or 1? If you want / expect 1, then

TotalDays: DateDiff("d",[Fdate],[Ldate]) +1

 

[LTDragon07]

I think I found the problem, I using the Total to do some min max, I had to just query the query.
Few off fix for now.