putting totals in an access table

[dan graziano]

Hi,

I had posted this before and would appreciate any ideas on this. I'm
trying to put a "total" for every row in an access table.
Unfortunately, some rows have "15+" in the "total" field instead of the
word "total".

Is there some sql code or a design method technique for finding all
those rows which have no "total" but have "15+" and converting those
"15+" to "total". If there already is a "total" in addition to "15+",
it's ok nothing needs to be done. This is only if there is a 15+ and no
total.

Here is a sample of the table to make it easier to understand:

country year agegrouping
Australia 1992 15+
Australia 1992 total
France 1993 total
Germany 1992 15+
etc.

There should be an agegrouping "total" for each country and year.

As mentioned, if there is a 15+, how could I change all the "15+" in the
original table to "total" when there is no "total" for that country and
year.

Thanks, and looking forward to your ideas.

Dan Graziano



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Bruno Campanini]

"dan graziano" <d3********@hotmail.com> wrote in message
news:41**********************@news.newsgroups.ws.. .

I had posted this before and would appreciate any ideas on this. I'm
trying to put a "total" for every row in an access table.
Unfortunately, some rows have "15+" in the "total" field instead of the
word "total".

Is there some sql code or a design method technique for finding all
those rows which have no "total" but have "15+" and converting those
"15+" to "total". If there already is a "total" in addition to "15+",
it's ok nothing needs to be done. This is only if there is a 15+ and no
total.

Here is a sample of the table to make it easier to understand:

country year agegrouping
Australia 1992 15+
Australia 1992 total
France 1993 total
Germany 1992 15+
etc.

There should be an agegrouping "total" for each country and year.

As mentioned, if there is a 15+, how could I change all the "15+" in the
original table to "total" when there is no "total" for that country and
year.

Thanks, and looking forward to your ideas.

Dan Graziano

Create and execute this query:
UPDATE TableX SET TableX.agegrouping = 'total'
WHERE ((InStr(1,[agegrouping],'15+')>'0'));

Every "15+" or "abc15+plk" will be updated into "total".

Ciao
Bruno