Form example - Queries

[simo7923]

I'm still learning on Access but i;ve made a fairly comprehensive database for lots of user to store information for trend analysis. They use a series of forms to input the data and can view some basic preset queries but what i would like to do now is make a form that the user could use to cary out trend analysis. Basically a simple form that they could enter the criteria on and then query the database. Anyone have an exaple of sucha form as i dont want the user going into making queries in design view.

 

[Dwight]

Look up parameter query in Help.

Basically you create the query but the user can set criteria e.g. date range on a form.

Hope this helps.

Dwight

 

[simo7923]

cheerz mate..tried this and didnt get too far.....gonna have to doa bit more training first. needs to do the likes of giving them the ability to save different queries and print them.....bodged one up at the mo though.cheerz