conditional format

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

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.
 
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.
Click to expand...

HTH,
Barry
 
Thanks Barry.

It works perfectly.

Barry Gilbert said:
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.
Click to expand...

HTH,
Barry

JB said:
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.
Click to expand...
Click to expand...
 
Back
Top