Query/Table Update

J

JGM

I have over 255 columns to place in one query. How can I
have a form look at two or more queries?
 
M

Marc

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

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
 
Top