Query not working in Access Runtime

[Guest]

Hi,
I made an mde file and packaged it with the wizard. When I push a command
button that is supposed to display results of a query, I get an error msg
with the SQL language of the query highlighted.
Do queries not work in runtime?
Thank you,
Karl

 

[Duane Hookom]

They should work fine. Consider sharing your code and your SQL syntax.

 

[Guest]

Hi Duane,
Thank you for responding. I packaged a bunch of files that I didn't need to
include. When I re-packaged deleting the garbage files, the query is working
fine now. Thank you for your help.
Karl

 

[Guest]

Hi Duane,
This query works fine in the regular application, but when I make the mde
file I get a response that says:
Function is not available in expressions inquery expression
(((tblPilot.Class)="First") And
((DateDiff("d",[tblPilot.ExamDate],Date()))>150)) Or
(((tblPilot.Class)="Second") And
((DateDiff("d",[tblPilot.ExamDate],Date()))>330))

Please disregard the earlier post of mine.
Thank you,
karl