Re: Tricky Delete Problem
- From: "John Spencer" <spencer@xxxxxxxxx>
- Date: Wed, 16 Nov 2005 08:17:48 -0500
So, if you have two rows with values
1;2;_;4;_
2;_;_;_;_
Do you want to delete just column 5 (based on the first row) or do you want
to delete columns 2 through 5 (based on the second row).
In a table (or query), you can only "delete" entire columns.
"Ida" <idta@xxxxxxxxxxx> wrote in message
news:1132118980.010810.48750@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Hi there, I've got another tricky problem.
>
> I have a table with 5 columns. Columns are called 1, 2, 3, 4, 5.
>
> One case:
>
> Columns 1 and 3 have numbers in them. Columns 2, 4 and 5 do not any
> data at all.
>
> I want to be able to delete columns 4 and 5 because those are the last
> two columns without data. Although column 2 does not have data, I want
> to keep it because it's before a column that does have data.
>
> Another case might be that only column 2 has data. I then would want to
> delete columns 3, 4 and 5. I want to keep column 1.
>
> Any ideas on doing this with CODE?
>
> I probably want to sum the columns and find the ones that equal 0. Then
> have a variable that keeps track of the column name that last had no
> data. Then I would delete the columns from that point on to the end of
> the table.
>
.
- Follow-Ups:
- Re: Tricky Delete Problem
- From: Ida
- Re: Tricky Delete Problem
- References:
- Tricky Delete Problem
- From: Ida
- Tricky Delete Problem
- Prev by Date: Re: How do I give a Union Query a "Primary Key"?
- Next by Date: Re: problem calculating an average in a one to many relationship
- Previous by thread: Tricky Delete Problem
- Next by thread: Re: Tricky Delete Problem
- Index(es):
Relevant Pages
|
