highlighting field in query or report

Hi, I'm trying to highlight a cost field if there is a change in the field
value. eg if previous cost was $2.20 for the last 9 weeks and this order
comes in at $2.35. Thank you.

Tony

Not very much information to go on...

What is your data structure? How are you determining "previous cost"? You
posted in "queries" newsgroup - how does this question relate?

--
More info, please ...

Jeff Boyce
Access MVP

Hi, basically it is from a PURCHASE ORDER table from a client, each PO has a
header file and a detail file, I receive this plus many other files in a
flat file and put them in Access format. Consequently, part number 12345 on
order number 67890 on 15 June 2003 could have a cost of $2.20, in the
clients COSTING or DEAL table, the price could be changed on 16 June 2003,
which would mean part number 12345 on order number 98765 on 19 June 2003
would have the new cost of $2.34 (or whatever it changed to). In a query, or
report I wish to highlight the COST field to illustrate when this field has
changed. We would normally sort this by part number, date order. Hope this
helps. Thank you, Tony.
"Jeff Boyce" -DISCARD_HYPHEN_TO_END wrote in message
...
Tony

Not very much information to go on...

What is your data structure? How are you determining "previous cost"?
You
posted in "queries" newsgroup - how does this question relate?

--
More info, please ...

Jeff Boyce
Access MVP

"Tony" wrote in message
...
Hi, basically it is from a PURCHASE ORDER table from a client, each PO has
a
header file and a detail file, I receive this plus many other files in a
flat file and put them in Access format. Consequently, part number 12345
on
order number 67890 on 15 June 2003 could have a cost of $2.20, in the
clients COSTING or DEAL table, the price could be changed on 16 June 2003,
which would mean part number 12345 on order number 98765 on 19 June 2003
would have the new cost of $2.34 (or whatever it changed to). In a query,
or
report I wish to highlight the COST field to illustrate when this field
has
changed. We would normally sort this by part number, date order. Hope this
helps. Thank you, Tony.
"Jeff Boyce" -DISCARD_HYPHEN_TO_END wrote in message
...
Tony

Not very much information to go on...

What is your data structure? How are you determining "previous cost"?
You
posted in "queries" newsgroup - how does this question relate?

--
More info, please ...

Jeff Boyce
Access MVP

Tony

Not sure if this is what you're after, but if you grouped by part number and
amount, you'd "see" each change. Does that get you closer?

--
Good luck

Jeff Boyce
Access MVP

I think that might work, I can do group headers on the report so that when
it changes there will be a new group. It's not highlighting but will work
the same. Thank you Jeff.
"Jeff Boyce" -DISCARD_HYPHEN_TO_END wrote in message
...
Tony

Not sure if this is what you're after, but if you grouped by part number
and
amount, you'd "see" each change. Does that get you closer?

--
Good luck

Jeff Boyce
Access MVP