Creating New Queries from Existing Database

B

bb3276

I somewhat new to Access so here is the problem I'm running into.

I have joined to two tables by a unique ID and I have listed the data fields
that I want to data on from the two tables. My problem is that each time I
run the query, I get back every data field in the two tables and I only want
to see the ones that I have defined in my query. What am I missing?
 
M

Marshall Barton

bb3276 said:
I somewhat new to Access so here is the problem I'm running into.

I have joined to two tables by a unique ID and I have listed the data fields
that I want to data on from the two tables. My problem is that each time I
run the query, I get back every data field in the two tables and I only want
to see the ones that I have defined in my query. What am I missing?
Click to expand...


Without seeing the queries, it's hard to tell, but it sounds
like you have the * item from each table in the query's
field list.
 
Top