By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,757 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

How to do this?

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.