reports in access

  • Thread starter Thread starter jon mich via AccessMonster.com
  • Start date Start date
J

jon mich via AccessMonster.com

I have a problem, I have to make a report where i can view several test
names. If there are 3 tests then I have to view the 3 tests but if there
are only 2 tests I have to view just those 2 tests?
Is there a possibility for working with an if-statement?
 
How you report data depends, in part, on how your data is organized. Can
you tell us a bit more about "tests"?
 
it's a program for cars who have to take some tests and I want to make a
report of the several tasks that will be done in several tests.each test
has a unique name. But I have 100 different tests and one car has to do 3
tests and another car has to do 2 tests but on a standard report you can in
your design wizard define 3 tests.
My question is:
Is there a possibilty to adjust your report on the amount of tests that are
being done on 1 car. So that there will be the amount of tests on the
report of 1 car but if they have done 2 tests that the 3rd test will be
erased but with 4 tests there will be added one.
 
Now I know more about what tests...

Next, I need to know how your data is organized. If you have multiple
columns to hold test1, test2, ... test n data, you have committed
spreadsheet on Access!

On the other hand, if your data is structured in a more normalized form, so
that each test for each vehicle is another row in a table, your report won't
have any trouble displaying as many "tests" as you have rows.
 
Here I have for each test a new row, but I don't find a solution to do this.
Is there a possibility to do this at runtime?
 
Would you post the SQL you are using to "gather" the test information for
the report?

Also, take a look at how Access designs reports -- the Details section would
be able to repeat for as many rows (i.e., tests) as you had. If you create
a Group Header for the vehicle, and put the test info in the detail section,
each vehicle could show as many tests as it had.
 
Back
Top