Newbie how-to

[Antinora]

Greetings! I have a table of student performance data including total credits earned and exam scores on 5 of each required exam for graduation (each exam score in its own column).

I would like to create a form so my bosses can choose an upper and lower limits similar to StartDate and EndDate but with scoring data (e.g. Students with all exam scores greater than 65 AND total credits greater than "x")

They want to predict potential grads now well before June 2016.

What is best practice? Is there sample code I could study to learn this technique?

I know how to create forms with command buttons to open previews of reports using VBA. The next level for me is to learn how to make the form more "variable" so an end user can pull queries for variable exam score and total credit data.

Do I create individual queries for each situation then have cmdButton open said queries? There must be a way to create temporary queries/report previews based on user input?

Thanks,

JA

 

[Minty]

There must be a way to create temporary queries/report previews based on user input?

There is - have a google for creating SQL queries in VBA code and then using the results as you require.

A simple example would be something like;

strSql = "Select * From tblResults Where TotalScore > 75 And TotalScore < 85"

Where any of the elements can be programmed from entries on forms.
There are dozens of examples on here of simple to complex versions of this.