[MS_AccessPros] Re: Problem with dates in queries

 

Hi Bob,

Have a look at,
http://support.microsoft.com/kb/194374

Regards, Clive.

--- In MS_Access_Professionals@yahoogroups.com, "topfuelbob" <rvalder@...> wrote:
>
> I have a calculated field in a query which works fine for all my users that have runtime 12.0.6612.1000.
> But for all my users that have runtime version 12.0.6425.1000 it fails with the error:
> "3075 (Function is not available in expressions in query expression)"
>
> The field value in the query is:
> "ActiveContract: IIf([ContractStartDate]<Date() And Not [ContractEndDate]<Date(),True,False)"
>
> So, question, am I using the correct syntax in that field?
>
> We are all in the UK but as far as I can tell, all machines are set up with the same regional settings regarding dates.
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

• New Members 7

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___