Add fields to a query

stealthdevil · November 16th, 2006, 12:31 PM

Hi,
I'm trying to create a query that gets the fields from a table. My problem is that there are only spots for 16 fields and my table has 24. Is there a way to add more than 16 fields to a query?

Thanks,
Dave

mmcdonal · November 16th, 2006, 12:47 PM

Just keep clicking them to add them. I think the limit is 255.

How are you "adding" them?

Open the query designer, add a table, then double click each filed you want.

mmcdonal

stealthdevil · November 16th, 2006, 12:56 PM

Thanks mmcdonal,
I guess I had a bit of a brain fart there. I ended up going into SQL view and adding them into the code. I'm pretty sure your way would be the thing to do though.

mmcdonal · November 16th, 2006, 12:59 PM

Either way works. Its just quick and dirty to use the designer view and keep clicking till you get what you want. SQL Server is that same way. No Query Analyzer for me... most of the time.

mmcdonal