Hello Guys and Girls,
Im trying to run a query that will run on a report that will show total.
All details are coming from the same table (Questions_tbl)
my query consists of 4 fields:
Field 1:
Supervisor name (I want this to display on the report even if there is not data there for them)
Field 2:
Date Check Requested (This will show/count the amount of dates (Between Start date and end- user asked, enter them self's)
Field 3:
File Check Status, this has "Requested","Checked". i only want the amount that are checked between the dates as in Field2.
Field 4:
Another file Check Status but this time i want it to count the amount "Requested" but i want to count any outstanding NOT Between the dates in field 2.
All details will go onto a report to show the figures for each Field.
Can anyone help, i have tried all sorts but keep ending in failure
I used Total and the count but it keeps showing the Supervisor name serveral times (i just want figures for that supervisor only), i also tried totals but in this case i think i need to use expression builder but it is a week area for me.
Can anyone help me or point me in the right direction?
Thank you Simon