I came in this morning to a problem with one of my queries. It worked fine
on Saturday, but when it tried to run last night, it produced this error:
"Function isn't available in expressions in query _expression_" with the
remainder of the message being made up of my query parameters.
Here is the SQL for my query.
INSERT INTO MAX ( PRTNUM_15, TNXDTE_15, TNXTIM_15, ORDNUM_15, TNXCDE_15,
STKID_15, TNXQTY_15, UDFKEY_15, REFDES_15 )
SELECT [Transaction History].PRTNUM_15, [Transaction History].TNXDTE_15,
[Transaction History].TNXTIM_15, [Transaction History].ORDNUM_15,
[Transaction History].TNXCDE_15, [Transaction History].STKID_15,
[Transaction History].TNXQTY_15, [Transaction History].UDFKEY_15,
[Transaction History].REFDES_15
FROM [Transaction History]
WHERE ((([Transaction History].TNXDTE_15)=Date()-1) AND (([Transaction
History].ORDNUM_15)="0000000000") AND (([Transaction
History].TNXCDE_15)="R") AND (([Transaction History].STKID_15)="FG" Or
([Transaction History].STKID_15)="WIP"));
This query has worked every night for the last 2 years, now all of a sudden
it no longer works.
As always, any help/advice is greatly appreciated! :)
==================================
Mike Bisson
Manager of IT & Logistics
Carthuplas, Inc.
V: 207-985-4972 x658 F: 207-985-2105
[EMAIL PROTECTED] http://www.carthuplas.com
[Non-text portions of this message have been removed]
YAHOO! GROUPS LINKS
- Visit your group "ms_access" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
