"Also is there a way where it as P1 P2 etc.... to rename them January Februaury etc..... Not important but would make the report look nicer."
Right-click in the top-left cell of the Cross-tab and left-click Cross-tab Expert
In the "Columns:" section, click on your Period Field
Click on Group...
This may help you get started:
Open the Field Explorer
Create a new Running Total field: VL TOT with the following parameters:
Field to Summarize = # of Hours
Evaluate
Beside "Use a formula" click in the X-2 and enter:
if {Remarks}="VL" then true
Click Save and Close
Click OK
Place the...
I am a novice Access 97 user.
I have a query with the following fields:
EqNo, PMNo, nextduedate, interval
These fields are used to schedule the next preventive maintenance (PM) for equipment.
I am trying to either update this query or else start a new query with the next 12 scheduled dates...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.