variable fields added to query

[bdjb]

Hello,
I'm using Windows 200 and MS Access 2003. We have a query that is pulling table from a table that can have variable fields imported. Is there a way to have the fields vary within the query? The table can have A00, B00, C00 or A00, A01, A02, B00, B01, C00, D00 etc.

Thanks

What happens if you get scared half to death twice?

Bob

 

[Golom]

You would need to build the query dynamically (i.e. in code) to make this happen. You can't use parameters or other run-time mechanisms to modify the fields (name or number) that are displayed in a query.

 

[bdjb]

Thanks Golom, I'll look into doing that.

What happens if you get scared half to death twice?

Bob