Create a iif type query (1 Viewer)

[JahJr]

I have a table with many columns; Master, L1, L2, L3, L4, P2, P3, T3, U, .
The Master column will have entries of 1-8.
If the Master column is 1, then the report needs to pull column L1.
If the Master column is 2, then the report needs to pull column L1, L2, & U

It goes on like this with different variances for each entry 1-8. I believe if someone can give me a example of how to do this i can figure it out from there.

Thanks

 

[khawar]

Can you explain in detail what are you trying to do
and if more than one rows are displayed with different number in column master how should your query look like

 

[JahJr]

I have the following columns;
ID, C#, Date, Master, L1, U1, O1, S1, T1, J, L2, U2, O2, S2, T2, L3, U3, O3, S3, T3, L4, U4, O4, S4, T4.

The Master column will have entries; 1, 2, 3, 4, 5, 6, 7, or 8.

I need a user form that will run query and a report.
In the user form there needs to be a option to select a range of dates.
Also a option to select 1, 2, 3, 4, 5, 6, 7, or 8. In the master column.

Depending on the selections the report will first narrow the search to the range of dates selected. Then
If 1 is selected the report will return;
ID, C#, Date, Master, L1, S1, T1, J.

If 2 is selected:
ID, C#, Date, Master, U1, S1, T1, J.

If 3 is selected:
ID, C#, Date, Master, O1, S1, T1, J.

If 4 is selected:
Return all columns with a entry

If 5 is selected:
Return all columns with a entry

If 6 is selected:
Return all columns with a entry

If 7 is selected:
Return all columns with a entry

If 8 is selected
Return all columns with a entry

Thank you in advance for your help I hope this explains it a little better.