Create a number of records base on a field value

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?

<brian.a.kennedy@gmail.com> wrote in message
news:1150375794.152147.293810@r2g2000cwb.googlegro ups.com...[color=blue]
>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?
>[/color]

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

Regards,
Keith.
www.keithwilby.com

brian.a.kennedy@gmail.com wrote:
[color=blue]
> 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?
>[/color]
Create a query that selects the data and sorts on the employee name

brian.a.kennedy@gmail.com wrote:[color=blue]
> 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?[/color]

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.