Simple Query

  • Thread starter Thread starter dhstein
  • Start date Start date
D

dhstein

In my design view I want to specify a criterion that the ProductVendorID is
=2. In I put a 2 in the criteria field but that didn't work. The field is a
long integer because it is a foreign key for the Primary Key (autonumber
format) in the vendor table. Any ideas ? Thanks for any help.
 
dhstein said:
In my design view I want to specify a criterion that the ProductVendorID
is
=2. In I put a 2 in the criteria field but that didn't work. The field
is a
long integer because it is a foreign key for the Primary Key (autonumber
format) in the vendor table. Any ideas ? Thanks for any help.
Click to expand...


You're talking about design view of the query, right? It sounds like it
should have worked. In what exact way did it not work? No records
returned, or an error message? Are you sure that you have a record in the
table with ProductVendorID = 2?

Maybe if you post the SQL view of the query, we'll be able to see what's
causing the problem.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2010 query for 3 tables 0
Need Suggestions to Eliminate Unplanned Table Behavior 4
Student Database - Access Newbie! 3
Keys 6
Loading Table with Associated Foreign Table 5
creating foreign key 2
Access Indeterminate relationship in many-to-many table (Windows 10, Access 2016) 5
Setting up building permit form ? 12

Back
Top