data in report

[steve111]

hi,

I have a form that has a drop down box in it
this drop down box allows me to select a number and that number refers to a part description

if I select the same number more than once . the query I run will show that number and description as many times as I have selected it in my form

when I run the report it will show me the number as many times as in the report an query but in the description it will only show it once

any ideas how to solve this please

thanks
steve

 

[The_Doc_Man]

This question is unanswerable without knowing more about the report and the query.

 

[steve111]

hi

I have a table called "groups" each record in that table has the id number and the description of that record. I have 200 records

example

no description
1 tyre
2 wheel

etc

now I want to advise a planner "up front"what I want to build although we don't know the piece that goes into each group


I now have a form that lets me select the groups I will use for a certain project

lets say I select no 1 then no 2 then number 2 again

the query shows
1. tyre
2. wheel
2 wheel

but the report shows

1. tyre
2 wheel
2


nothing in the description the second time in 2


hope that's helps more

 

[The_Doc_Man]

I understand the behavior but to answer this question, our experts will need to see structural information, probably for the table used to store the data that drives the report and also for the query used to extract the data.

In general, if your data set is properly structured and those line items are in the detail section of the report, you should see the same data for each line that has the same numeric index for the part number.

 

[Minty]

It sounds as if the report has hide duplicates set for the description field.