razorrussian
New member
- Local time
- Today, 01:01
- Joined
- Feb 29, 2020
- Messages
- 1
Hello All,
long time lurker, first time poster!
I have been wracking my brain trying to figure out how to do this - I have a query in access that goes through one of my tables - tblSelections (with fields Primary Key, email, firstname, lastname, eventdate, and Partysize, the query asigns a RND value to its primary key(auto Number), and picks the top 30 rows based on a date entered into a parameter box.
We use this as sort of a lottery system, so that is why we are randomizing the PK.
If needed, I can attach a sample of my database, but what I want to do is get this query to do is instead of returning only the first 30 lines, I want it to keep running until the Total of the PartySize column reaches a specified number.
In the past this query just returned the first 30 rows on a specified day, which means that the total headcount was between 30 and 180, but we want to fine tune this to get as close to 150 as possible!
Any ideas would be greatly appreciated, I will upload a sample shortly. Thanks all!
long time lurker, first time poster!
I have been wracking my brain trying to figure out how to do this - I have a query in access that goes through one of my tables - tblSelections (with fields Primary Key, email, firstname, lastname, eventdate, and Partysize, the query asigns a RND value to its primary key(auto Number), and picks the top 30 rows based on a date entered into a parameter box.
We use this as sort of a lottery system, so that is why we are randomizing the PK.
If needed, I can attach a sample of my database, but what I want to do is get this query to do is instead of returning only the first 30 lines, I want it to keep running until the Total of the PartySize column reaches a specified number.
In the past this query just returned the first 30 rows on a specified day, which means that the total headcount was between 30 and 180, but we want to fine tune this to get as close to 150 as possible!
Any ideas would be greatly appreciated, I will upload a sample shortly. Thanks all!