Parameter Query in Microsoft office 2007

[ajditty]

I am trying to do a Parameter Query in M.O 2007 and my parameter is set to
enter Product ID which is a numerical value. When I put in a product ID it
pulls in all items not just the specific Product for whose Product ID I had
entered. I am using the parameter box at the top in the ribbon.
HELP!!

 

[MGFoster]

I am trying to do a Parameter Query in M.O 2007 and my parameter is set to
enter Product ID which is a numerical value. When I put in a product ID it
pulls in all items not just the specific Product for whose Product ID I had
entered. I am using the parameter box at the top in the ribbon.
HELP!!

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Switch to SQL view and make sure the WHERE clause looks something like
this:

WHERE column_name = [Product ID]

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSRodOYechKqOuFEgEQIAkACg9PezxBufJBdLEQ4t7U1Zse/xwGAAoJiW
ZO/cxdR2dSUD56NunAR1sulR
=C2VU
-----END PGP SIGNATURE-----