Multi-Table query pulling all fields, not just selected, into results

[Amthyst826]

Two tables linked by a common field.


Criteria is limiting results that match a specific number pattern
Query works... except
I have only specified a handfull of the fields from the two tables, the results are pulling ALL columns (fields) from the tables.

This is new behavior to me, I have created similiar queries in the past that only show the fields I select in the results.
I select each field and add it to the query, I do not drag all fields or the asterisk which does the same thing.

I have been creating and recreating this query and similiar ones for a week. Unless I delete the columns from my table, which I do not want to do, my query results include every field in the tables.

Thank you!

[pbaldy]

What is the SQL of the query?

[Amthyst826]

Sorry, I'm a gui girl, learning as I go, I do not know what you are asking.

[pbaldy]

In the upper left corner should be a View icon. Change it to SQL.

[June7]

Switch the query to SQL View to see the SQL statement.

Does it have wildcard (*) in the fields selection?

Copy/paste statement into post.

[Amthyst826]

SELECT AllPOExtract.[Item Number], [ANA 53 w BASE table].DESC1, [ANA 53 w BASE table].DESC2, [ANA 53 w BASE table].BASE, [ANA 53 w BASE table].STATUS, [ANA 53 w BASE table].PTREV, AllPOExtract.Site, AllPOExtract.[Purchase Order], AllPOExtract.Supplier, AllPOExtract.[Supplier Name], *
FROM AllPOExtract LEFT JOIN [ANA 53 w BASE table] ON AllPOExtract.[Item Number] = [ANA 53 w BASE table].ITEM
WHERE (((AllPOExtract.[Item Number]) Like "#####-###"));

[pbaldy]

Did you miss that * at the end of the field list?

Welcome to the site by the way. I was just down in your area (Norwalk) visiting my mother-in-law, on the way to LAX.

[Amthyst826]

I see it in the SQL view, I tried removing it, but I get an error. I looked at the Design View and do not understand why the asterisk is there.
I've been using access for years, this is the first time I've had this issue. How do I get the asterisk out?

And thank you for the welcome I am an Orange County Native.

[pbaldy]

You have to remove the comma before it as well.

[Amthyst826]

Ah-Ha! Any idea why after years it started putting that asterisk there?? I'm not doing anything different (that I know of)

[pbaldy]

Not offhand. I'd guess that you accidentally double-clicked on it when selecting fields.

[Amthyst826]

I'm pretty sure that I didn't. I've been working on queries for several weeks with this problem. Thanks for the assist!! I'll go mark this one solved.