Create a number of records base on a field value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

brian.a.kennedy@gmail.com - 15 Jun 2006 13:49 GMT

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?

Reply to this Message

Keith Wilby - 15 Jun 2006 14:00 GMT

>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

Reply to this Message

salad - 15 Jun 2006 16:25 GMT

> 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

Reply to this Message

pietlinden@hotmail.com - 16 Jun 2006 04:04 GMT

> 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.

Reply to this Message