Simple Query

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.
 
D

Dirk Goldgar

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.
 
Top