Generate a Query Using a Form

C

clara

A report is based on a query and this query should be generated by a form.
The problem is the controls on the form can not be assign to the query as a
parameters becasue some transformation must be applied to the controls input.

Clara

thank you so much for your help
 
J

Jeff Boyce

Clara

It sounds like you are trying to use a form to help you generate a query.

Isn't that what Access already offers in its query design view?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

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

Can I save a sql statement generated by a search form? 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
DLookup in Continuous form 0
Generate a Query by Form 1
Including Null values in query design 6
How to Change criteria on a saved query using VBA 0
Make reference to controls on a report 1
Parameter query 1

Top