Conditional Formatting in a query

  • Thread starter Thread starter LMB
  • Start date Start date
L

LMB

Hi Guys,

Access 2000. I have a crosstab query with a date field "Expiration Date". When the date in the field becomes older than today, I want there to be some flag to let the user notice. Is there a way to do this in a query or do I need to make a report? I hope I can do it in the query because there will be additions to the columns and I don't think you can make a report that will add the columns as they are added to the query.

Thanks,
Linda
 
There is no conditional formatting in an Access query. You will have to use a report. While it is difficult to create a report based on a crosstab query, it is not impossible.

On my website are two samples that illustrate how. I created one and Duane Hookom the other. Here are links to them:

http://www.rogersaccesslibrary.com/download3.asp?SampleName=CrossTabReport.mdb
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Cross Tab'

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

Hi Guys,

Access 2000. I have a crosstab query with a date field "Expiration Date". When the date in the field becomes older than today, I want there to be some flag to let the user notice. Is there a way to do this in a query or do I need to make a report? I hope I can do it in the query because there will be additions to the columns and I don't think you can make a report that will add the columns as they are added to the query.

Thanks,
Linda
 
Thanks Roger
............but RATS!<g>
There is no conditional formatting in an Access query. You will have to use a report. While it is difficult to create a report based on a crosstab query, it is not impossible.

On my website are two samples that illustrate how. I created one and Duane Hookom the other. Here are links to them:

http://www.rogersaccesslibrary.com/download3.asp?SampleName=CrossTabReport.mdb
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Cross Tab'

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

Hi Guys,

Access 2000. I have a crosstab query with a date field "Expiration Date". When the date in the field becomes older than today, I want there to be some flag to let the user notice. Is there a way to do this in a query or do I need to make a report? I hope I can do it in the query because there will be additions to the columns and I don't think you can make a report that will add the columns as they are added to the query.

Thanks,
Linda
 
Back
Top