D
Dan J
I am trying, without any success, to count a number of units on an Access
report within one of two headers. The table structure is very simple with
only one table in the database. There are six fields within the table; the
first one is a counter (AutoNumber), the second is a text field. The next
three fields are all Number fields and the last is a Memo field. There are
only 689 records in the table.
The information is:
Overseas container numbers [Container #] (total of 18) -- (Number field)
+ Pallets [Pallet #] (within the container - usually 11 per container) -
(Number field)
+ Blocks [Block #] (on the pallet - between 3 and 4 per pallet) -
(Number field)
+ Memo [Comments] (comments about the block) - (Memo
field)
I have a query that filters the memo field to only the damaged blocks within
the entirety of the table. I then wrote the report with a Container header
and a pallet header then listed the blocks in the detail. Within the header
of the pallets, I get a Count of the blocks that works properly. I am now
trying to get a count of the pallets within the Container header so I know
how many pallets were bad in each container. The quantity returns the total
number of pallets that is equivalent to the total number of blocks, not
pallets. Long story short, for each block there is a corresponding pallet
even though several blocks may be on the same pallet. Is there a way (via
function or whatever) that can filter out the duplicates which is the bottom
line problem that I am having. I am not literate, at all, in VB and am using
the Report Wizard initially to create the basis for the report. I do know
how to use most of the controls with the Report module, just not with VB.
Thanks, in advance, for the help.
Dan Johnson
report within one of two headers. The table structure is very simple with
only one table in the database. There are six fields within the table; the
first one is a counter (AutoNumber), the second is a text field. The next
three fields are all Number fields and the last is a Memo field. There are
only 689 records in the table.
The information is:
Overseas container numbers [Container #] (total of 18) -- (Number field)
+ Pallets [Pallet #] (within the container - usually 11 per container) -
(Number field)
+ Blocks [Block #] (on the pallet - between 3 and 4 per pallet) -
(Number field)
+ Memo [Comments] (comments about the block) - (Memo
field)
I have a query that filters the memo field to only the damaged blocks within
the entirety of the table. I then wrote the report with a Container header
and a pallet header then listed the blocks in the detail. Within the header
of the pallets, I get a Count of the blocks that works properly. I am now
trying to get a count of the pallets within the Container header so I know
how many pallets were bad in each container. The quantity returns the total
number of pallets that is equivalent to the total number of blocks, not
pallets. Long story short, for each block there is a corresponding pallet
even though several blocks may be on the same pallet. Is there a way (via
function or whatever) that can filter out the duplicates which is the bottom
line problem that I am having. I am not literate, at all, in VB and am using
the Report Wizard initially to create the basis for the report. I do know
how to use most of the controls with the Report module, just not with VB.
Thanks, in advance, for the help.
Dan Johnson