Dynamic query

S

sergiosr

Hi,

I have a query with 14 fields and I need to break that in many small
queries. I was wondering if it would be possible instead of creating
more queries, to make this query dynamic. I would like the user to be
able to choose which fields to be included in a query, every time that
he runs this query.

Is this possible?

Thanks,

Sergios
 
D

Duane Hookom

Can you explain why you need to allow a user to select fields? Normally
users select a limited group of records, not fields. Any answer to your
question might depend on your needs and reasons.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Using Office Forms and dynamically updating the excel backend 0
dynamic calculated field in query 3
How to Change criteria on a saved query using VBA 0
QBF & Query Malfunction 0
Make table query: [Enter 1] AS Test 1
Some mail merge fields not pulling into document 2
Running balance for debit and Credit using query in Access 2007 0

Top