Creating New Queries from Existing Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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