Re: highlighting field in query or report
From: Tony (islatormenta_at_hotmail.com)
Date: 05/30/04
- Next message: John Spencer (MVP): "Re: Format Date"
- Previous message: Tiffany: "Re: Format Date"
- In reply to: Jeff Boyce: "Re: highlighting field in query or report"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 30 May 2004 17:06:43 -0600
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" <JeffBoyce_IF@msn.com-DISCARD_HYPHEN_TO_END> wrote in message
news:%23r%23fRLmREHA.3124@TK2MSFTNGP12.phx.gbl...
> 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>
>
- Next message: John Spencer (MVP): "Re: Format Date"
- Previous message: Tiffany: "Re: Format Date"
- In reply to: Jeff Boyce: "Re: highlighting field in query or report"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
