Query returning fields not chosen

[cam2era]

Hi. I'm new to Access 2010 and I've run accross a perplexing problem. My queries return all the fields in a chosen table, in spite of the fact that I've chosen just a subset of fields. The fields I've chosen show up in the order which I request them. Then the remaining fields are inserted afterwards.

Is this a known issue? The database was originally created years ago in Ver 2003.

Thanks,


-Ernie

[RuralGuy]

Post the SQL View of your query please.

[cam2era]

Sql view:

SELECT [SKS_MinMetab-Diet].serial_id, [SKS_MinMetab-Diet].visit_number, [SKS_MinMetab-Diet].fgf, [SKS_MinMetab-Diet].pth, [SKS_MinMetab-Diet].d2425, [SKS_MinMetab-Diet].d25_d3, [SKS_MinMetab-Diet].d25_d2, *
FROM [SKS_MinMetab-Diet];


I now see the , * (comma asterisk). I can delete this in sql view, but why would it show up in the first place?

[RuralGuy]

I really don't know but if your issue is resolved then go ahead and use the Thread Tools and mark this thread as Solved.

[cam2era]

OK. Will do. At least I can move forward now.

Thanks.

[RuralGuy]

You're very welcome and welcome to the Forum.