I created a query containing my order details and products tables. I have entered no criteria as of yet, I have only entered the basic information. When I open the query, the 'Enter Parameter Value' dialog box pops up requesting Products.Quantity. The field 'quantity' doesn't even exist in the Products table. I have checked to make sure there are no references to Products.Quantity, but apparently I am missing something. Can anyone help this Newbie?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Enter Parameter Value when not needed
- Thread starter caldee
- Start date
FoxProProgrammer
Programmer
It sounds like Products.Quantity is in the Where clause of the Query and it can't find that value. Have you opened the Query in SQL view or Design View to see if it has a Where clause? dz
dzaccess@yahoo.com
dzaccess@yahoo.com
Junior1544
Technical User
How about posting you SQL, it'll help us see what you did with the query...
--James junior1544@jmjpc.net
Life is change. To deny change is to deny life.
--James junior1544@jmjpc.net
Life is change. To deny change is to deny life.
- Thread starter
- #4
- Status
Similar threads
