Recent content by robsmith

  1. R

    Combining Two Aggregation Queries

    Thanks Namliam, I see your point. It's my first database and the names aren't great. Will access automatically update query names used in other queries if I change them? Thanks again.
  2. R

    Combining Two Aggregation Queries

    Hi arnelgp, yes I wanted to sum ballsFaced based on venue, batsmanId and League then sum ballsFaced just on batsmanId and League. I want to then divide the first sum by the second sum and this was the only way I could think of doing it.
  3. R

    Combining Two Aggregation Queries

    Thanks Namliam. I was thinking there may be a way to combine them into one to reduce the number of queries but I'll do that instead,
  4. R

    Combining Two Aggregation Queries

    Hi guys, I am trying to combine two queries aggregation queries in Access but I am struggling with the syntax. I want the final query to return the following fields: venue, League, batsmanId, ballsFacedByGrLg and ballsFacedbyLg. Can anyone point me in the right direction? Thanks SELECT...
  5. R

    Solved Find Different Matches in Same Field

    Hi arnelgp, this is perfect. Thank you so much for all you help.
  6. R

    Solved Find Different Matches in Same Field

    Hi Arnelgp, yes and it is being returned by the query. I want to exclude Events that only have one StartDay, even if it is the day selected in the dropdown. Thanks
  7. R

    Solved Find Different Matches in Same Field

    Hi Arnelgp, thanks for this. I've tested it but it seems to be returning results where there is only one StartDay. Eg. in the attached if you select Monday and filter for Event 4451 you'll see the issue.
  8. R

    Solved Find Different Matches in Same Field

    Thanks DBguy. How to do I specify a StartDay?
  9. R

    Solved Find Different Matches in Same Field

    Hi DBguy, I just want to return a list of the records with multiple StartDays. So in the extract it would be all records apart from the one with the Event starting with 5. Thanks
  10. R

    Solved Find Different Matches in Same Field

    Hi DBguy, I've attached a small extract. There are 3 Events, two of which have multiple StartDays and one has only one StartDay. Thanks
  11. R

    Solved Find Different Matches in Same Field

    Hi, I have a table called EventData containing various fields including StartDay and Events. Some Events have multiple StartDays each of which are separate records. Is it possible to run a query to return records that match a specified start day (eg Monday) but also have at least one other...
  12. R

    Using A Calculated Field to Perform Another Calculation

    Thanks Pat, I’ll try that.
  13. R

    Using A Calculated Field to Perform Another Calculation

    Hi arnelgp, To calculate BatAve I need to sum all the runs then divide by the number of times batsmen were "out". There are lots of different ways of getting out so the easiest way was to say anything other than "not out". Thanks
  14. R

    Using A Calculated Field to Perform Another Calculation

    Hi, I have put together the query below to perform various calculations. It works ok but I am trying to now calculate the average of the BatAve results, ie the average of all BatAves in League. I thought AVG([BatAve]) AS LgBatAve would work but I just get a "Subqueries cannot be used in the...
  15. R

    Macro To Run Saved Imports and Code

    Hi, I am trying to put together a macro to run various saved imports followed by some code. I have done the saved imports and they work but I can't seem to get the code to run. The code is in a module and I have included it below. Can anyone point me in the right direction? Thanks Option...
Top Bottom