Search results

Sorted. Thanks again

Ah right! Doh!

...I hadn't so thanks for pointing it out. Glad I'm not going mad. However, tried downloading and updating it and it says it's already installed. :(

Thanks. It's getting there. It's all coming flooding back! Have a weird issue at the moment with a corrupt query. I've tried re-writing it from scratch, repairing the front and back end all to no avail. Very odd...

I was running both Refresh and ReQuery and they seem to interfere with each other. Just Requery on its own works a treat so thank you for checking. :)

Thanks for asking and yes. :)

Hi, I'm new to Access (but not coding) and have a datasheet which is just populated from a table. I have put a macro behind the 'ID' field so the user can click the ID field and it runs the Macro to bring up eitther a New Record or to edit the existing record. When I click the 'New' link and...

Well spotted that man. That could be a real issue if you have several layers of SQL. A good reason to use the AS keyword sparingly and only if absolutely necessary. :)

Attached a full backend DB with a cut down front end. Use SeriesID 2 or go to the Calculate Series menu and select the September 2019 series.

Just need to know how to upload the files...I don't appear to have an option to attach files to a post. :)

Thanks IslaDogs. I can see it works in the mini DB but I get the same top 2 results ignoring the grouping.

Yes, I've tried playing around with the Order By clause but to no avail. I need the ORDER to be ASC for time as I want the fastest times. But if I use DESC i just get the expected slowest 2 times. The only other difference is that my underlying table is itself a query built on various other...

Weird. I really cannot see the difference. (btw, how do I get that nice table image into this post? Anyway, here's my raw data: RaceRunner RaceTimeSecs Steve 1376 Steve 1387 Sara 1616 Sara 1698 Andrew 1783 Andrew 1722 Andrew 1718 Charlotte 1927 Charlotte 1972 Sue 1769 Sue 1816 Jill 1805 Jill...

Thanks IslaDogs. Ok, so I am just getting the TOP 2 results of ALL runners rather than the top 2 results for each runner. Note of course that the time is not necessarily unique unlike the OrderID in the example you sent. Here's the SQL: SELECT * FROM qrySeriesPositionOverallIndividual AS Q...

Hi Guys, I want to calculate the top 'N' results of each runner within a series of races. I have the following SQL which nicely generates the valid runners (those who have run the requisite number of races in the series): SELECT Q.SeriesName, Q.DateFrom, Q.DateTo, Q.RaceRunner, Q.RaceTime...

Thanks for the tips guys but I would like to use the same input query to run a report just grouped differently to try and keep the number of queries and reports to a minimum. And anyway, I was just wondering if it is logically possible in Access 2013 reports to decide, for whatever reason, not...

Hi, I am printing a report where I want to print UP TO the first 3 lines in each Group. In this case it is a report for runners by Age Category and I just want to show the top 3 (max) in each age category. I believe the Format event runs before the Print event so I was wondering if I could...

Nz works. Thanks

Sorry, the ![SeriesID] = IIf(IsNull(Me.SeriesID), 0, CInt(Me.SeriesID)) line gives the error

I know I can do it in VBA but from the answers above there doesn't appear to be a MACRO expression to do this. MessageBox definitely doesn't. All the examples are VBA code but I was looking for the lazy MACRO alternative. Hey ho, VBA it is. Thanks, :)