Search results

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...

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...

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...

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...