using column count function in a union query

[ozzy]

Hello,



I made an union query from 3 tables, but 2 field of tables are using column count and column widths functions.
Since I can not open union query in design view i cannot use this function, i guess i need to use SQL coding.
Can you please tell me how to use?
here is my sql view for my union query:
The fields which uses these functions are "InputMaterial" and "OutputMaterial" ( Column Count 2 \ Column Widths 0;4 )

SELECT [CcName],[InputMaterial],[OutputMaterial],[ModuleName]
FROM tbl_ControlAndCommunication

UNION SELECT [EsName],[InputMaterial],[OutputMaterial],[ModuleName]
FROM tbl_EnergySaving

UNION SELECT [EstName],[InputMaterial],[OutputMaterial],[ModuleName]
FROM tbl_EnergyStoring;


Another thing is that i want to filter query using combo box in a form so i cant do this either since design view is not usable
[Forms]![frmModuleSearch]![Combo1]

[ranman256]

Your filter would have to be put in each qry in the union.

Tho your union qry looks good here, so your col.count functions may be to blame.

[ozzy]

Thank you for ur answer but, it didnt help me at all.
i dont know how to code column count function and column width function in this union qry code

[pbaldy]

At first I didn't understand what you meant by having those properties in a query (they would normally be properties of a combo box on a form). Now I wonder if you are using lookup fields? If so, you'd need to include the other table in each appropriate section of your UNION query, and get the desired field from the lookup table. By the way:

http://access.mvps.org/access/lookupfields.htm