Query/Table Update

  • Thread starter Thread starter JGM
  • Start date Start date
J

JGM

I have over 255 columns to place in one query. How can I
have a form look at two or more queries?
 
JGM said:
I have over 255 columns to place in one query. How can I
have a form look at two or more queries?
Click to expand...

Hi
The source of a query may be another query. Go into query designer, and
choose the relevant queries as the record sources rather than tables.

However to have such large displays will be very difficult for a user to
visually process correctly - maybe the process should rather be broken into
subforms or the data normalised.

hth
Marc
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Counting multiple memberships 1
Access #Error & Excel Pivot 0
ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Access stripping decimal places in query 1
Query Question 3
Access Dcount (multiple criteria) 3

Back
Top