Group Using Conditional Format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way i can group like items in a datasheet or tabular form? I'd
like the first column to have the main group. i'd like the first item of a
series of rows to be visible and the subsequent like items in the same row
invisible (like an Access report or Pivot table report.). See the samples
below.

Part# wo#
026WOW 123456
026WOW 156985
026WOW 169875
026WOW 198563
0270OW 123654
0270OW 135698
0270OW 136546
0270OW 135796
035WOW 1965887
035WOW 203558

-- NEW WAY --
part# wo#
026WOW 123456
156985
169875
198563
0270OW 123654
135698
136546
135796
035WOW 1965887
203558
 
Hi Jackle,

The only way I can think of achieving this is to create a temporary table
and then drive the datasheet or form off the table - as you know it's easy in
Excel to make a formula in one cell refer back tio the cell in the row above,
but there's no way that I've discovered to do the same in an Access table,
datasheet or continuous form. (And also you can't have a continous subform
within a continuous form, so there's another solution out of the window!!).

Now the only problem with creating a temporary table to achieve your planned
layout is this: if you want to add new records or edit existing ones it gets
quite complex! How good are you with VBA and either ADO or DAO?

I did briefly toy with another idea (two fields for part#, inputting to one,
with code to copy from 'field 1' to 'field 2' and then deleting from 'field
1' if another record already had that value) but the correct sorting of WO#
within each Part# section would only work if the first time you used a new
part# was always going to be the time with the lowest WO#, if you see what I
mean. Rats!!

I realise this doesn't answer the question, but if you want me to follow up
any of these ramblings please let me know.
 
Back
Top