How can I apply a "strikethrough" font format in a query?

[jebba]

I am trying to create a report and a query that will indicate if there are any matching items between two lists by formatting the matching item(s) using a "strikethrough" font (a line crossing out the word).

The query will compare two lists, a "weekly items list" and a "customer's no list".

I would like to create an output that would show the "weekly items list" for each customer.

The "weekly items list" will be the same, except that anytime a there is a match between the two lists, the item will appear, but with a line through it.

I am also open to any suggestions that would indicate the match.

Thanks in advance

 

[MichaelRed]

Can't do it "IN" a query (or even several of them). The RESUILTS of the quer[y |ies] may be formatted in a form or report.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over