loop and query structure

[reidn]

Hello All,



I have a Form where one selects a range of dates to pull information from a table. I need to display a score for each day in the range selected. The score is calculated by dividing the total nonconformant by the total inspected.

So I have a query (based on period selected) that fills a listbox with Julian date, Actual Date, Quantity Inspected, and Quantity Nonconformant from the table. From this list box I need to group all the info for one julian day and determine the score from it, repeating until the entire date range has been covered and all information displayed. I am completely stumped as to how to move from here...

Thank you for all of your help and if this doesnt make sense I can go into more detail,

Reid

[June7]

Why are you trying this in a form? Sounds like something that should be done in a filtered report using Grouping & Sorting with summary calcs.

[rpeare]

so you are entering two different dates and you want to see one line per day within that range displayed in a list box? Do you intend to do anything with the items in the list box (like select one and do something with it?) If you intend to use the data in the list box for anything but a visual aid a list box is not necessarily your best option. Also can you give an example of what your data looks like in your table and how you want the end result to look within your list box.

[reidn]

June, I am new to access so I have no idea what you are talking about but I will look into it.

Rpeare, yes and for each day I need the score to be calculated and displayed (There are about 100-200 records per day). Also the information will likely be placed in an excell sheet later. The Table I am drawing data from looks like...

Date: Quantity N/C: Quantity Insp: Inspector:
1/8/11 0 6 Bobert
1/8/11 3 3 Laquisha
1/9/11 3 6 Ahkmed
1/9/11 0 6 Cletus
1/9/11 0 6 Frank

And so on... Is that what you were asking?

The listbox, using above info, should look like...

Date: Score:
1/8/11 0.333
1/9/11 0.166

[rpeare]

Here's a quick example, the list box is populated when you exit the end date field. I changed your table field names because you should try to stay away from using reserved words (Date, Name, Count, etc) and also stay away from special characters (/, #, $, %, etc) and spaces in your field names or object names in your database, they will only cause you problems as you become more involved in programming.

[reidn]

rpeare,
That is exactly what I was looking for. Thank you for helping me out so much!!

[reidn]

rpeare,

I tried to integrate it and it keeps telling me to enter parameter values for everything

[rpeare]

Then you're not correctly converting everything for your setup, that parameter pop up only comes up if you've got an unidentified item, this can be a misspelling of a field name, a table name, a query name, a control name (text box, list box, etc). Without seeing an example of your database it would be nearly impossible for me to tell you where to look.

[reidn]

nevermind fixed it

[reidn]

and what?? I thought yall were supposed to guess what they were... These forums arent what they used to be. I did enter something wrong (resulted from a / character)