Sorry this is so long. My need for knowledge just seems to grow by leaps and bounds.
My question is two fold. First when I am looking around the net for ideas I see lots of code such as (SELECT...CASE...) but no one ever says specifically where this is supposed to be typed in a query, report, etc? Or can it be typed in modules and called somehow by the query, report...?
Second and most important to me is the fact that I am trying to print a report based on a query. So far that works fine if I use the data loaded in the table already. However, I have 4 fields I would like to break out into criteria. Then I want to only print the results that satisfy a test. The test would go something like...if grade = 1st & subject = math then use the standard that matches the standard number from 1st grade standard table. There are probably 10 standards per subject per grade. Here is where it gets confussing because each standard has approximately 10 items called benchmarks. In addition each benchmark has another 10 items called indicators.
Right now I am putting all data into a Main table and then pulling out all the 1st Grade records with a query and printing the report from the query. I have standards, benchmarks, and indicators setup as numbers 1-10 at this point. I would like to be able to print what each of those numbers represents on the report rather than just printing the number.
i.e. 1st grade standard 1= reads a variety of materials, benchmark 1=comprehends the difference between a book and a magazine, indicator 1= reads a book at the appropriate level.
I am assuming I need to set each set of criteria in a separate table but I'm not sure what would be the most efficient method for doing so.
Thanks in advance for any help.
My question is two fold. First when I am looking around the net for ideas I see lots of code such as (SELECT...CASE...) but no one ever says specifically where this is supposed to be typed in a query, report, etc? Or can it be typed in modules and called somehow by the query, report...?
Second and most important to me is the fact that I am trying to print a report based on a query. So far that works fine if I use the data loaded in the table already. However, I have 4 fields I would like to break out into criteria. Then I want to only print the results that satisfy a test. The test would go something like...if grade = 1st & subject = math then use the standard that matches the standard number from 1st grade standard table. There are probably 10 standards per subject per grade. Here is where it gets confussing because each standard has approximately 10 items called benchmarks. In addition each benchmark has another 10 items called indicators.
Right now I am putting all data into a Main table and then pulling out all the 1st Grade records with a query and printing the report from the query. I have standards, benchmarks, and indicators setup as numbers 1-10 at this point. I would like to be able to print what each of those numbers represents on the report rather than just printing the number.
i.e. 1st grade standard 1= reads a variety of materials, benchmark 1=comprehends the difference between a book and a magazine, indicator 1= reads a book at the appropriate level.
I am assuming I need to set each set of criteria in a separate table but I'm not sure what would be the most efficient method for doing so.
Thanks in advance for any help.