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
 
Back
Top