Which option did you choose? Do you still have the bytWorkingDay field? If so, look for record(s) with no 0 or 1.
BTW I don't wish to sound presidential but a 'please' or 'thank you' here or there would be nice.
Which option did you choose? Do you still have the bytWorkingDay field? If so, look for record(s) with no 0 or 1.
BTW I don't wish to sound presidential but a 'please' or 'thank you' here or there would be nice.
Oh Of Course. I am so sorry for my terrible manners Sir.
May you be blessed with all that you wish for. I do apologise for my lapse in acknowledging all your assistance. My BAD!
I'm using the option with the "bytWorkDay" field. I have checked and all the rows are populated with either a 0 or 1
Thanks
Well, I can't get the below to fail in the Immediate Window even when I have a missing record for a date, a record with dtmDate missing, or a record with nothing in bytWorkDay -
?DSum("bytWorkDay", "Table1", "dtmDate Between #12/06/17# And #01/12/18#") - 1
I suggest you step through your code and print in the Imediate Window the line which errors.
Cross posted here http://www.utteraccess.com/forum/ind...ic=2046493&hl=
Im Sorry - Did I make a mistake by posting on another forum? Im not sure of the etiquette. I do apologise if I offended anyone.
I am just trying to learn.
Yes and no
Have a read here https://www.excelguru.ca/content.php?184
Get it working Archie?
@Minty
Thank You for that informative read. I will definitely make sure I abide by that advice. Once again I do apologise.
@ knarfreppep
Im getting all sorts of errors. If possible, and I know I made a BIG BOOBOO by cross posting, and Im not sure If I can do this, but could you download the DB from that post and check it out. If not I can upload here (again not sure of the procedure)
I feel like a deer caught in the headlights here ... LOL
I'm not a member of the other place ... pls upload here.
PS I wouldn't be too upset about Novice Minty ... I look to help people, not compare posts on multiple sites ... oops, I'll probably have some remedial reading to do myself.
DB.zipOk. DB attached.
DB and 3 text files with the various functions I have tried, one being the one you graciously provided.
I was only making a polite observation, it's only to make new posters aware of the etiquette.
I'll go and change out of my habit now...
Hi Guys
Thank You For All The wonderful help and assistance. I sat until the wee hours and finally went this route:
I used my existing queries to create a table, too lazy to go create them myself!! Once done I updated my SQL with Insert & Update Queries and "sub queries". They work perfectly and the speed is excellent. I still use the date functions within my Updates but have researched that my SQL wasn't the most efficient, so I re-wrote some of it.
Basically the solution was to have the query write to a table, and then a sub query to update it when changes were made.
I don't know if that makes sense - but WOOHOOO!!! I have something that works and is very fast.
Thanks Guys