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

Create a number of records base on a field value

P: n/a
I am a rookie and am looking to create records based on a field value.
For example - I currently have sales data for three employees:
Employee 1 has sold 12 units, EE 2 has 8 and EE 3 has 10....I want to
create a table that will show 30 records instead of 3 and list the
employee infor as well as the order #. Any advice?

Jun 15 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
<br*************@gmail.com> wrote in message
news:11**********************@r2g2000cwb.googlegro ups.com...
I am a rookie and am looking to create records based on a field value.
For example - I currently have sales data for three employees:
Employee 1 has sold 12 units, EE 2 has 8 and EE 3 has 10....I want to
create a table that will show 30 records instead of 3 and list the
employee infor as well as the order #. Any advice?


I would suggest having a look at the Northwinds example database that ships
with Access.

Regards,
Keith.
www.keithwilby.com
Jun 15 '06 #2

P: n/a
br*************@gmail.com wrote:
I am a rookie and am looking to create records based on a field value.
For example - I currently have sales data for three employees:
Employee 1 has sold 12 units, EE 2 has 8 and EE 3 has 10....I want to
create a table that will show 30 records instead of 3 and list the
employee infor as well as the order #. Any advice?

Create a query that selects the data and sorts on the employee name
Jun 15 '06 #3

P: n/a

br*************@gmail.com wrote:
I am a rookie and am looking to create records based on a field value.
For example - I currently have sales data for three employees:
Employee 1 has sold 12 units, EE 2 has 8 and EE 3 has 10....I want to
create a table that will show 30 records instead of 3 and list the
employee infor as well as the order #. Any advice?


it's possible to do this with simple looping code, but why do you want
to do something like this? Sounds like a bad design (well, based on
the information provided). There may be valid reasons for doing
something like this, but you haven't explained why you want something
like this.

Jun 16 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.