Page 2 of 2 FirstFirst 12
Results 16 to 29 of 29
  1. #16
    knarfreppep is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Feb 2015
    Location
    Adelaide, Australia
    Posts
    106
    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.

  2. #17
    archie1_za is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Oct 2017
    Posts
    48
    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!

  3. #18
    archie1_za is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Oct 2017
    Posts
    48
    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

  4. #19
    knarfreppep is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Feb 2015
    Location
    Adelaide, Australia
    Posts
    106
    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.

  5. #20
    Minty is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001

  6. #21
    archie1_za is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Oct 2017
    Posts
    48
    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.

  7. #22
    Minty is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    Yes and no

    Have a read here https://www.excelguru.ca/content.php?184

  8. #23
    knarfreppep is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Feb 2015
    Location
    Adelaide, Australia
    Posts
    106
    Get it working Archie?

  9. #24
    archie1_za is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Oct 2017
    Posts
    48
    @Minty

    Thank You for that informative read. I will definitely make sure I abide by that advice. Once again I do apologise.

  10. #25
    archie1_za is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Oct 2017
    Posts
    48
    @ 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

  11. #26
    knarfreppep is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Feb 2015
    Location
    Adelaide, Australia
    Posts
    106
    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.

  12. #27
    archie1_za is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Oct 2017
    Posts
    48
    DB.zipOk. DB attached.

    DB and 3 text files with the various functions I have tried, one being the one you graciously provided.

  13. #28
    Minty is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    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...

  14. #29
    archie1_za is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Oct 2017
    Posts
    48
    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

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Please help this Access class is killing me
    By NovicetoAccess in forum Access
    Replies: 1
    Last Post: 07-14-2015, 12:53 PM
  2. Report and Query Speed ..
    By fekrinejat in forum Access
    Replies: 6
    Last Post: 06-17-2013, 03:18 AM
  3. How to speed up my Query
    By Cfish3r in forum Queries
    Replies: 2
    Last Post: 10-18-2012, 02:55 AM
  4. This Relationship is killing me
    By minnetonka in forum Access
    Replies: 1
    Last Post: 05-02-2011, 10:31 AM
  5. Killing open applications using VBA
    By zippy483 in forum Programming
    Replies: 4
    Last Post: 03-03-2010, 10:04 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums