flag (***) when the part number changes

[Garry]

Hi

My query will output part numbers for labels in ascending order

Depending on the number of labels

Is it possible to incorporate a flag (***) when the part number changes

i.e.

123
123
123 ***
456
456 ***
789
789
789
789
789
789
789 ***

etc, regards, Garry

 

[Jeff Boyce]

Garry

Your example seems to say you want to put the flag (***) on BEFORE the part
number changes, not after.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John Spencer]

I think you could do this in a report with relative ease. In a query, I
can't think of a method that would work to do this unless you have
some other field to specify the order of the identical part numbers.



'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

 

[Garry]

Jeff, i do need the flag before the part number changes

John, I have done this already and it works great in access

The labels have quite a bit of text that is formatted in normal, bold and
italic font

I cannot do this with an access report, I therefore need to export the data
to a xls file
as I can then use with microsoft word

Any thoughts

 

[John Spencer]

No other thoughts. I'll repeat unless you have some other field(s) that would
let you specify which of the indentical part numbers was the "last" one, I can
think of no way to generate a flag to mark the "last" one.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

 

[Garry]

Hi, I have a separate query that will count the number of each group of part
numbers if this would help

ie - part number 123 = 3, 456 = 2

regards, Garry

 

[John Spencer]

You have to be able to apply a ranking number, so that you get something like
123 1
123 2
123 3

Then you can set the flag "***" when the ranking number and the count are
equal. Again you need some field (or combination of fields) that can tell you
that this "123" comes before that "123".

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County