Flatten a table

[Rick Slater]

I have a table that has common item numbers for different
stockrooms. It is possible to have a different unit of
issue for each stockroom. Presently I can only see the
data formatted as;

Stockroom_1, item_1, unit_1
Stockroom_2, item_1, unit_2

But I would like to beable to create a flattened record
that displays as;

item_1, unit_1/unit_2

with the units strung togther in a single field. Can
anyone give me some assistance??

 

[John Vinson]

But I would like to beable to create a flattened record
that displays as;

item_1, unit_1/unit_2

with the units strung togther in a single field. Can
anyone give me some assistance??

See:
Return a concatenated list of sub-record values
at:
http://www.mvps.org/access/modules/mdl0004.htm

<stolen from Allen Browne, thanks Allen>

 

[Rebecca]

This is, I think, the same thing I am asking in my post "Make table query,
report, module, macro" but did not get any answers on it.
I do not understand or even know where to start with visual basic so the
link that is given here doesn't make sense to me. Can it be explained what
I do with the visual basic code?

Thanks in advance.
Rebecca
A very basic user!