value of a field determine the number of records in a new table/query

[baggieboy]

Hi



I'm trying to use the value in field B to determine the number of times the value in Field A is repeated in a new table or query.

So trying to get from a table that looks like this:

Field A	Field B
1	4
2	2
3	6

To one that looks like this:

Field A
1
1
1
1
2
2
3
3
3
3
3
3

Not sure if this is best done with a query, or with VBA?

Many thanks in advance

John

[CJ_London]

think you'll need to use vba, don't see how you could do it with a query

[vicsaccess]

baggieboy, having a hard time understanding why you would want to replicate the same data in a table multiple times unless there is more fields that make each entry unique? if field B of the second table has a unique value then that would explain it and make it simpler to do. I think more background is needed because depending on the circumstances will answer your question.

[June7]

Would need VBA to write records to a table - usually called a 'temp' table because the data is purged each time the process is run.

Why do you need this? Is it a one-time event or will this be done periodically?