How to do this?

[Leon]

Hi all,

I am new on Access.
What would be the best solution for this?
We are getting access files from our suppliers in the following
format.

ID Geography Age Group Sex Count

1 Australia 15-19 years Male 3218

2 Female 2975

3 20-24 years Male 3695

4 Female 3458

each access file contains a few tables (say first_table, second_table
.... etc) like in this kind of format.

Now what I would like to do is create a program that goes through all
tables (ie, first_table, second_table ... etc) in a access db and for
a table in each column (ie, Geography) is value is null(ie, id 2 is
null) then insert value above("Australia"). So result will be

ID Geography Age Group Sex Count

1 Australia 15-19 years Male 3218

2 Australia 15-19 years Female 2975

3 Australia 20-24 years Male 3695

4 Australia 20-24 years Female 3458

and product it in .txt file.

For this scenario, what program should I use? Macros, VB or asp.net?
What would be the easiest?

Thanks

[Larry Linson]

It would be very unusual for the Geography and Age Group fields to be
_omitted_ from subsequent records in an Access table when they are
duplicates of the previous record. Doing so would appear to me to require
extra work for the creator of that data, if its actual source is an Access
table. Perhaps the data is obtained by importing into Access from a
different source, perhaps a spreadsheet?

Yes, you can write code to do what you want, but it would seem to me to be
worth an inquiry to the provider of the data to see if they would be willing
to fill in the empty fields.

Also, is the "Age Group" field a text field? It appears that it is, which
means that for some types of processing, you will need to parse it and
separate the starting and ending ages.

I do not know how you can accomplish what you want without writing some VBA
code. The easiest probably would be Data Access Objects (DAO) code, rather
than ActiveX Data Objects (ADO). That's not usually a "beginner topic", but
if you can verify the assumptions, and describe the fields, perhaps someone
here could provide you a sample to help.

Larry Linson
Microsoft Access MVP

"Leon" <yo******@yahoo.com> wrote in message
news:8a**************************@posting.google.c om...

Hi all,

I am new on Access.
What would be the best solution for this?
We are getting access files from our suppliers in the following
format.

ID Geography Age Group Sex Count

1 Australia 15-19 years Male 3218

2 Female 2975

3 20-24 years Male 3695

4 Female 3458

each access file contains a few tables (say first_table, second_table
... etc) like in this kind of format.

Now what I would like to do is create a program that goes through all
tables (ie, first_table, second_table ... etc) in a access db and for
a table in each column (ie, Geography) is value is null(ie, id 2 is
null) then insert value above("Australia"). So result will be

ID Geography Age Group Sex Count

1 Australia 15-19 years Male 3218

2 Australia 15-19 years Female 2975

3 Australia 20-24 years Male 3695

4 Australia 20-24 years Female 3458

and product it in .txt file.

For this scenario, what program should I use? Macros, VB or asp.net?
What would be the easiest?

Thanks