T
Tony
Hi, I first tried this newsgroup two days ago and the response was
outstanding. If at all possible if someone could help with these situations.
1) In an invoice number field, I want to keep the original number, but I
want to generate a "short number" eg. an invoice number R09876, I want to
keep it in the original field, but run a query for the "short number" field
that will drop letters and zeros for comparison.
2) How can I highlight a field such as "cost" when the value of the field
changes, such as cost goes from 2.20 to 2.35?
3)On query or report, can I highlight duplicate values such as Supplier Name
or Number?
thanks so much and tell me if I'm being too greedy with so many requests,
Tony
outstanding. If at all possible if someone could help with these situations.
1) In an invoice number field, I want to keep the original number, but I
want to generate a "short number" eg. an invoice number R09876, I want to
keep it in the original field, but run a query for the "short number" field
that will drop letters and zeros for comparison.
2) How can I highlight a field such as "cost" when the value of the field
changes, such as cost goes from 2.20 to 2.35?
3)On query or report, can I highlight duplicate values such as Supplier Name
or Number?
thanks so much and tell me if I'm being too greedy with so many requests,
Tony