What is the max. fields in an Access query

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

Guest

I am some what new at this so.....

I am trying to produce a report from an Access database with links to a
number of tables. The problem, I don't seem to have enough field in the
query. I am producing an "Excel" spreadsheet from the query. The report can
have up to 38 fields. The query function seems to only have 15 fields. Is
there something UI am not seeing?

Thanks
 
What error message are you getting when you try to add a 16th field?

Jeff Boyce
<Access MVP>
 
the_Chomp said:
I am some what new at this so.....

I am trying to produce a report from an Access database with links to a
number of tables. The problem, I don't seem to have enough field in the
query. I am producing an "Excel" spreadsheet from the query. The report can
have up to 38 fields. The query function seems to only have 15 fields. Is
there something UI am not seeing?

Thanks
Click to expand...
Just keep adding the fields it Access should add the needed columns.
Or are you getting an error message?

I just put at least 30 fields into a query using Access 2003.

gls858
 
I am some what new at this so.....

I am trying to produce a report from an Access database with links to a
number of tables. The problem, I don't seem to have enough field in the
query. I am producing an "Excel" spreadsheet from the query. The report can
have up to 38 fields. The query function seems to only have 15 fields. Is
there something UI am not seeing?
Click to expand...

Access supports up to 255 fields in a Table or Query, so that's not
the problem. It may just be the query grid - try selecting the last
ten columns in the grid and click the Insert menu item, and insert
columns.

John W. Vinson[MVP]
 
Back
Top