Search results

Well, thinking about it RUNNERID + RACEID is unique for all records. By definition each runner can only race once (as far as I know! lol). Would that work?

Hi Isladogs, If I am passing data from the docmd.openreport why should me.Openargs return null? Anyway, I have a more pressing issue as real world data has shown a hole in the logic for the race series calculations. I have looked on the web and the issue I have is common but all the solutions...

There isn't a unique ID for the line nor does there need to be for TOP 'N' that's the whole point of it. I have looked on the web and the issue I have is common but all the solutions seem to be using dates or hard-coded data and ones that aren't are using T-SQL, Oracle or some other query...

I have some VBA code: DoCmd.OpenReport strReportName, acPreview, , , , "TESTING" but when I inspect me.openargs in the report Load or Open event Me.Openargs shows as null. What am earth am i doing wrong?

No that won't work. There isn't a unique record ID on the incoming data but anyway the issue is that I need to check if the result in the underlying data is in the top 3 results for this athlete. The trouble is the Top 3 results contain 6,6 and 7 so as it comes across each record, each record...

There is but the problem is that qrySeriesResultsIndividual has in this case 4 lines of results 6th, 6th, 7th and 7th. As the SQL runs through each row in the underlying table qrySeriesResultsIndividual it finds 6th and 6th is in the top 3 results and so on for the next 3 results so it pulls in...

OK, so I'm going to try and explain this as best I can. Some of you will be a little familiar with the race timing database I am writing and have helped massively in getting it to where it is. A problem has just been highlighted when calculating the overall series' results. An athlete runs in...

The reason I don't want to do that is because I want a report which shows all the races tha ANY team has been in for control purposes. SO....IS THERE a way of knowing how many columns there are on a report like in a recordset using rst.fields.count or must I pass the number as a parameter to...

Hi Guys, I didn;t realise I could use the generic recordset for ALL recordsets. I'll update the code. The reason for knowing the number of columns is that I only want to print the line on the report if ALL columns that SHOULD have data actually have data. If you can imagine for example that...

Thanks. Yes but in the report itself, I need to know that all columns that should have data have data. I can just pass the parameter through to the report form the VBA unless there is a similar count columns method for a report?

Thanks DBGuy. Yes, luckily I had a backup. :) All good again. Just need to pass a parameter to the report to tell me how many columns to check which I think is the simplest way as I already have the data from the VBA which calls the report. Thanks again for the support.

Hi, I have just been working on Crosstab queries and reports with parameters and have got it all working (or so I thought). I am now getting an error on the Querydef function where I am setting up the parameters of the query in VBA before calling the report. I have no idea why this isn't now...

Thanks Isladogs and DBGuy. Yes, it helps to understand the theory (for me anyway) otherwise it's just monkey say monkey do so I appreciate the lesson in the underlying principles. Actually quite straightforward really once I got what exactly was happening. I did have a bit of an issue with...

Hi DBGuy, thanks. I was thinking that the actual text box names are being overridden. Or is that not the case? I have text boxes in my report txtRaceData1,2,3,4 etc. Do those names remain available to me? I'm still not exactly clear what technically the whole pre-processing has done to the...

Well wouldn't ya know I managed to work it out so thank you for your patience. It took a bit of working out as to how to set the parameter up in VBA but that works perfectly now too. So the only thing left to do is for me to change the hard-coded column names in the PrintDetail event to a...

Current report shows the actual report output. :)

DB uploaded :) I need the parameters because the user selects the series they want to report on. Access Reprots ( as someone else pointed out) doesn't let you use the report wizard on crosstab queries unless you have completed the 'IN' part of PIVOT but I have no idea why because if you just...

Hi Isladogs, sorry no I couldn't make any sense of your example. It seemed highly complex and didn't seem to relate to what I need to do. I'm sure it does I am clearly not experienced enough to understand it which is rather because as your output shows, like the school report, that is exactly...

TBH I'm utterly confused. Clearly this is above my paygrade. The 'workarounds' seem almost incomprehensibly complicated and why is looping through the columns so ridiculous Isladogs especially when compared with the alternatives? None of the links seem to have led to a comprehensible...

Well, all, just an update. So the answer to the first question regarding why access won't allow you to create a report based on a crosstab query without the PIVOT...IN being complete is, it's just a bug in Access! Access has no problem running a report without jsut a simmple PIVOT [field_name]...