Create a number of records base on a field value

[brian.a.kennedy]

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?

[Keith Wilby]

<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

[salad]

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

[pietlinden]

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.