Search results

  1. R

    Appending Data on Import Importing Headers as well as Data

    Hi, I have created a saved import using the "Append a copy of the records to the table..." option but it is importing the headers from the source file resulting in the header row appearing as a record in the table. Is there a way to avoid this? I am using Access 2016. Thanks
  2. R

    Find the Most Recent of Consecutive Dates

    Hi Arnelgp, I don't understand how that will help? Thanks
  3. R

    Find the Most Recent of Consecutive Dates

    Hi, I have a table of horses that have run on consecutive days (extract below). I would like to run a query to return the record of the second of the consecutive days. I have tried using Max() but sometimes a horse has run on consecutive days on multiple occasions so it just returns the very...
  4. 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.
  5. 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.
  6. 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,
  7. 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...
  8. R

    Solved Find Different Matches in Same Field

    Hi arnelgp, this is perfect. Thank you so much for all you help.
  9. 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
  10. 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.
  11. R

    Solved Find Different Matches in Same Field

    Thanks DBguy. How to do I specify a StartDay?
  12. 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
  13. 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
  14. 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...
  15. R

    Using A Calculated Field to Perform Another Calculation

    Thanks Pat, I’ll try that.
  16. 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
  17. 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...
  18. 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...
  19. R

    Solved Query Dividing by 1 Giving Incorrect Results

    Hi, I am trying to run a simple query where I divide values by 1. Many of the results are correct but often they are wrong. This is the query: And here is an extract of the results: EVENT_ID SELECTION_NAME BSP BSPR PPWAP PPWAPR MORNINGWAP MornWAPR 116821865 Investissement 2 0.5...
Top Bottom