Hey Richard and Guys, I am try to create a Query to view the Maintenance Plans by Status and Chart the Results by the Scheduled Start Date. If the Maintenance is "Overdue", "Due", and "Not Due". I am wondering if I should create different Queries to for each Status?
Adam Schwanz
@Reply 2 years ago
If the only difference is the status, I would just make it a Parameter Query or link it a textbox on a field if you have status.
James HopkinsOP
@Reply 2 years ago
Oh ok Adam, I am trying count the Number or Percentage of "Overdue, Due, and Not Due Yet" Maintenance Plans by the Scheduled Date.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access TechHelp.
