By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,069 Members | 1,272 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,069 IT Pros & Developers. It's quick & easy.

Splitting query into equal recordsets

P: n/a
Hi Guys,

Hopefully you will understand my problem.

I have a spreadsheet that i import into a table which contains job
data. Using a number of queries i can filter the data as requested.
What i now want to do is have the database split the data into
seperate recordsets ready to export back to a spreadsheet.

Example:
Spreadsheet contains 26 jobs (6 require a two person team - 15 only
require a one person team)
We have 2 (two person teams)
We have 4 (one person teams)

I need the database to be able to split the recordset up equally so
that each team (1 or 2) receive 6 jobs each

Eg
each two man team receives 3 two man jobs and 3 one man jobs = 6 jobs
total each
each one man team only receives 6 one man jobs (never any two man
jobs) = 6 jobs total each

aplogies if you dont fully follow my requirements, i am an
intermediate access user and with direction should be able to follow
any suggestions.

Thanks in advance.
Jan 25 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 25 Jan, 12:21, LL-JK <lee.bagga...@mapelectrics.comwrote:
Hi Guys,

Hopefully you will understand my problem.

I have a spreadsheet that i import into a table which contains job
data. Using a number of queries i can filter the data as requested.
What i now want to do is have the database split the data into
seperate recordsets ready to export back to a spreadsheet.

Example:
Spreadsheet contains 36 jobs (6 require a two person team - 30 only
require a one person team)
We have 2 (two person teams)
We have 4 (one person teams)

I need the database to be able to split the recordset up equally so
that each team (1 or 2) receive 6 jobs each

Eg
each two man team receives 3 two man jobs and 3 one man jobs = 6 jobs
total each
each one man team only receives 6 one man jobs (never any two man
jobs) = 6 jobs total each

aplogies if you dont fully follow my requirements, i am an
intermediate access user and with direction should be able to follow
any suggestions.

Thanks in advance.
changed the number of jobs above as they were incorrect sorry.
Jan 25 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.