We have a folder checklist. All the data is in 8 columns as checkboxes. I can sum the columns and it gives me a total of true responses which is great. My dilema is I cannot get it to sum between 2 dates. Specifically Oct 04 through Dec 04.
My table includes job name, date of job, customer signature, safety meeting(checkbox), customer signature(checkbox), drawings(checkbox), job measured(checkbox), etc. etc.
Lets see... here is roughly what my query looks like:
Actually it doesn't work...You can't SUM on those fields because they don't lend themselves to math operations...
You need to determine what they are first...and I did the test for both between and > and <=...I believe > and <= will be more effecient..at least it is in SQL Server...the fact that you try to sum the columns misleads you in to thinking that there is something wrong with the dates
EDIT: Make sure you change the properties of the new column to be General Number