Entering parameter in query gives error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a simple query and when I enter [Enter Date YYMM:] it gives me error
"MS Jet DB engine does not recognize [EnterDate YYMM:] as a valid field name
or expression. Can anyone give a suggestions as to why?

PS: the field comes from a query where it creates it DATE1:
MID([INDATE],2,4) andd data comes from AS400.

Thanks
 
SELECT QRY_CER_2005_SALES.ACCT, QRY_CER_2005_SALES.SLMN,
QRY_CER_2005_SALES.DATE1, QRY_CER_2005_SALES.INEXTP, QRY_CER_2005_SALES.INEXTC
FROM QRY_CER_2005_SALES
WHERE (((QRY_CER_2005_SALES.DATE1)=[ENTER DATE FOR CER YYMM:]));
 
I have a simple query and when I enter [Enter Date YYMM:] it gives me error
"MS Jet DB engine does not recognize [EnterDate YYMM:] as a valid field name
or expression. Can anyone give a suggestions as to why?

PS: the field comes from a query where it creates it DATE1:
MID([INDATE],2,4) andd data comes from AS400.

Thanks
Click to expand...

Please post the full SQL view of your query.

John W. Vinson[MVP]
 
Thank you, but i am actually re-writing the whole this, plus I am not sure
yet how to combine the 2 queries I have so I just build a different query and
set a macro to run it. If I get the same error message I will post it again.
However, could it possibly be a memory issue?

Thanks
--
If at first you don''''t succeed, destroy all evidence that you tried.


John Vinson said:
I have a simple query and when I enter [Enter Date YYMM:] it gives me error
"MS Jet DB engine does not recognize [EnterDate YYMM:] as a valid field name
or expression. Can anyone give a suggestions as to why?

PS: the field comes from a query where it creates it DATE1:
MID([INDATE],2,4) andd data comes from AS400.

Thanks
Click to expand...

Please post the full SQL view of your query.

John W. Vinson[MVP]
Click to expand...
 
Back
Top