Flatten a table

  • Thread starter Thread starter Rick Slater
  • Start date Start date
R

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??
 
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!
 
Back
Top