Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Chart based on query

Status
Not open for further replies.

BeffyMar

Programmer
Jul 20, 2000
17
US
I have several charts that are based on a query. The criteria for the date field is<br><br>Between Now() and Now()-[Enter Number of Days]<br><br>This works well... but I want to get the number of days that they entered and put that on the heading of the chart<br><br>ex. All Equipment in the Past 90 Days<br><br>How can I accomplish this? Will I have to rewrite all of my queries to accomplish this?<br><br>Thanks in advance,<br>Mary Beth
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top