Append Query with mulitple select queries (1 Viewer)

kobiashi · Aug 31, 2018

hi

so i have a form with 8 unbound sub forms, each sub form is attached to a select query, each query is filtered uniquely, such as one date field is filtered to show just todays events,

the date that is displayed in these sub forms can be changed for the source table, so i need the ability to save the current data in the sub forms, to a unique id, so it can be viewed historically.

i thought of using a append query. so my question is can i create an append query that has multiple select queries?

WayneRyan · Sep 3, 2018

Kobiashi,

Your append query should be a union query; even if some of the components have no rows.

Wayne

kobiashi · Sep 3, 2018

Hi Wayne Ryan

Thanks for the reply, can I use a union query even if the fields are not the same in the select queries?

jdraw · Sep 3, 2018

kobiashi,

Details of union query and example from w3schools

WayneRyan · Sep 4, 2018

Draw,

That’s a good link ... but they say “usually” the same named columns. To not confuse kobiashi: each of the Union queries must agree in data type and number.

Wayne

jdraw · Sep 4, 2018

Wayne agreed.

I was hoping the OP would read these, then try the example.
(from w3schools)
The UNION operator is used to combine the result-set of two or more SELECT statements.

Each SELECT statement within UNION must have the same number of columns
The columns must also have similar data types
The columns in each SELECT statement must also be in the same order

WayneRyan · Sep 4, 2018

J,

Duh ... I quickly scanned it and missed the very first part !

I was just focused on the note.

Wayne

Append Query with mulitple select queries (1 Viewer)

kobiashi

Registered User.

WayneRyan

AWF VIP

kobiashi

Registered User.

jdraw

Super Moderator

WayneRyan

AWF VIP

jdraw

Super Moderator

WayneRyan

AWF VIP

Similar threads

Users who are viewing this thread