Search results

I'm using Access 2016 and unique values doesn't appear in the properties list :( I have noticed the query does run a tad slow but I'm new to Access so no idea how to rewrite it so that it's not a DSum unfortunately. I'm guessing it's a subquery that will be needed though?

Here's the query I have written: SELECT MemberContact.membershipno, membercontact.firstname, memberbasic.joindate, WIRecords.WIID AS WInID, wirecords.WIDate AS WInDate, DSum("daysteps","stepcount","stepsdate between #" & Format([WinDate]-1,"mm/dd/yyyy") & "# And #" & Format([WinDate]-7...

My gut instinct told me it was that - I just wasn't sure how to correct the problem :) Thanks very much!

On my form I would like to have all but 1 field ("MembershipNo") hidden until the MemberNo is entered. One of the other fields is called FirstName. I have tried the following code: Private Sub MembershipNo_AfterUpdate() If MembershipNo = "" Then Me.FirstName.Visible = False Else...

You're a genius arnel - sooooooo much faster now :) Thank you so much (again!) :D

I have a table that contains different people's step count per day. I then need the query to calculate the total number of steps for a person for both the previous week and 3 weeks before the WInDate (a changeable date of when they last visit)

I'm building a query that needs to do quite a lot of sums. As a result, its execution time is around 8 seconds - which obviously isn't great! The sums add up either 7 or 21 DLookup values - all of which I have input separately. Just wondering if there is a more efficient way of writing the sums...

WOW! You're an absolute genius - it now works perfectly. Thank you soooo much! :D Could you explain why adding the format bit works so that I know for future reference? I'm guessing it's something to do with American Vs. UK date formatting?

I'm really confused by a query I'm building. It seems to work for most of my data, except for certain dates for some reason. Here's a simplified verion of my table (StepCount): StepsID .. MemNo ..... StepsDate ... DaySteps 1 ................... 1 .......... 20/08/2016 ..... 3434 2...