Search results

No radio buttons are selected when the form initally opens. Let say the user clicks 'yes' to postcode only, then clicks requery: The values in the 'Yes' label for the 'Account' would update based on the number of records where postcode is yes and account is yes The values in the 'No' label for...

Thanks for the reply Gasman I holds my hands up, the values in the picture ive made up (although the real data its possible for the figures not to match given the way the data is in the table) Im not sure i understand how to implement the dcount. In my picture theres 6 labels that will need to...

Morning, Im looking to start a discussion on the best method to approach based on the image below: What im reviewing is a form with various radio buttons, when all options are selected for each group the user clicks the requery button. The part im getting stuck with, and confused is the test...

Brilliant - Sorted it, thank you

I have updated it to: SELECT tblSourceData.[Athlete], tblSourceData.[Gender], tblSourceData.[Competition Date], tblSourceData.[Swim], tblSourceData.[Bike], tblSourceData.[Run] FROM tblSourceData; WHERE tblsourcedata.[swim] is null or tblSourceData.[bike] is null or tblSourceData.[run] is null...

Thank you, I cant believe its that simple. Any how, I still cant do it properly. This is my SQL: SELECT tblSourceData.[Athlete], tblSourceData.[Gender], tblSourceData.[Competition Date], tblSourceData.[Swim], tblSourceData.[Bike], tblSourceData.[Run] FROM tblSourceData; WHERE...

I want to run a query that shows a set criteria in 1 of 3 rows. Example my table is as follows: Name - T1 - T2 - T3 John 01:45 54:16 Steve 18:24 37:00 I want my query to only show any that contain blanks I've set the criteria in all 3 to 'is null' but that...

Thank you CJ I didnt realise it was so sensitive. Its doing something but not 100% sure what exactly - Could you break it down slightly so I understand how its doing what I need I get the gist but a little explanation so I learn from my experience if thats OK? Why does it start with SELECT...

Thank you for the reply, not really sure what I am doing with this SQL. I created a new query and modified your code to this: SELECT T.* FROM tblSourceData T INNER JOIN (SELECT Top 5 Competition Date FROM (SELECT DISTINCT Competition Date FROM tblSourceData) ORDER BY Competition Date) D ON...

I have a team of athletes who compete in 3 different sporting events. I am trying to work out how I can get my query to only look at the 5 most recent events I want to score them as a percentage variance based on target times set to complete each sporting event. Any help is greatly...

Thank you very much for the updated one. Ive amended the module but for some reason everyone is scoring 50 points. My criteria for scoring is below: If tm < 1098 Then GetScore = 50 ElseIf tm < 1140 Then GetScore = 40 ElseIf tm < 1200 Then GetScore = 30 Else GetScore = 0 End If...

Hi Yeah after the colon is seconds Thanks

I cant really change my raw data, I have about 20,000 records for people in the races. Some names are in there 50 times as they have completed so many I tried to follow plogs SQL and already created another table with thresholds and points if the time falls between those times. But I am unsure...

Thanks for the reply, Where exactly would the JOIN go within the SQL? So far I have: SELECT tblSourceData.Athlete AS Athlete, Min(tblSourceData.Swim) AS MinOfSwim, Min(tblSourceData.Bike) AS MinOfBike, Min(tblSourceData.Run) AS MinOfRun, Count(tblSourceData.Athlete) AS EventsCompleted...

I have just changed the module to reflect the times I need but it shows an error as soon as I change it The swimming times in my table are in this format 22:00 to represent 22 minutes, as soon as I do: If time < 18:00 Then - It goes straight to a compile error Any ideas?

Thank you very much. Just to throw a spanner in the mix, if I add more sports (hurdles) I would use the same technique to produce a score - But how would I add scores from all sports together, use a DSUM? Thank you in advance

Thank you for the reply - Appreciated I tried this but get an error when adding the expression: GetScore(([Swim])) tried using: score: GetScore(([Swim])) but same issue Any thoughts on what I maybe doing wrong?

Afternoon everyone Im pretty new to this so please go lightly on me. I have a table: name, swimtime, score john 18:00 smith 22:00 I m looking to score swimmers based on the time they swam a race - Example such as scoring 50 points if they finished in under 20 minutes - I thought a...