Too many fields in my query

[jamespeters01]

Hi all,

I have a simple query that has about 6 fields from 2 tables. Basically the problem (well its not so much a problem, more an annoyance!) is that when the query is run, every single field from both tables is displayed (about 40 fields!). Any ideas / solutions ??


Thanks


James

 

[jebry]

Hi James!

The only way for that to happen, as far as I know, is for you to tell the Access to return all of the fields. This is usually done by saying Select * From etc. Assuming that you actually name the specific fields you want, you may want to look and make sure you didn't accidently include the * as well and, if you did, remove it from the query. If the * isn't there, then post the SQL for us to look at.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[jamespeters01]

Jeff,

Thanks mate. I knew it would be something stupid !