conditional format

[Guest]

I have a form with a list of invoice numbers. The numbers begin with either
"AP" or "SI". Each record has an "invoice_number" and "ident" field.
Each invoice number can have an Ident of "AP" or "SI"

In the following example I need to change the formatting of "AP:377" to
highlight the fact that an "SI" has been created.

SI:375
AP:376
AP:377
SI: 377
AP:378
AP:379
SI:380

Any help would be appreciated.

 

[Guest]

I think you'll need to start in your query, a count column that will indicate
that there are multiple records where the last three digits are the same.
Then in your conditional formatting, you can use the expression "[CountOfInv]

1" or something like that.

HTH,
Barry

 

[Guest]

Thanks Barry.

It works perfectly.

I think you'll need to start in your query, a count column that will indicate
that there are multiple records where the last three digits are the same.
Then in your conditional formatting, you can use the expression "[CountOfInv]

1" or something like that.

HTH,
Barry

I have a form with a list of invoice numbers. The numbers begin with either
"AP" or "SI". Each record has an "invoice_number" and "ident" field.
Each invoice number can have an Ident of "AP" or "SI"

In the following example I need to change the formatting of "AP:377" to
highlight the fact that an "SI" has been created.

SI:375
AP:376
AP:377
SI: 377
AP:378
AP:379
SI:380

Any help would be appreciated.