highlighting field in query or report

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

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