Tags: access, column, database, delete, excel, jeff, microsoft, mysql, oracle, referring, sheets, spread, sql, time, together, usingspared

Delete data from one column only

On Database » Microsoft Access

3,443 words with 1 Comments; publish: Fri, 30 May 2008 20:48:00 GMT; (25046.88, « »)

Thanks again Jeff but you keep referring to spread sheets I am not using

spared sheets. I used Excel to put the information together the first time so

I could make sure I had all the fields needed. I then entered all the

information on the products accordingly, and then imported this information

in to a table. From there I made the Form so I could enter more data or look

up products, change prices and so on. The form does all the mathematical

functions needed. When I add a new product it is added to the end of the list

in the table. I now have over 130+ products. What I am trying to do is clear

the first data field for each product.

Qty Price Item Supplier

2 2.50 product1 supplier1

6 1.00 product2 supplier2

10 5.00 product3 supplier3

5 .50 product4 supplier4

And so on.

New products are added to the bottom of the list in the table from the Form.

It also does my sorting. All I want to do is delete all the data in the Qty

column and keep the data stored in Price, Item, and Supplier ECT.

"Jeff Boyce" wrote:

> I repeat, Access is NOT a spreadsheet. If you ONLY imported data from Excel

> and turned it into a table, chances are very good your data is not

> well-normalized. So what, you ask? So Access offers relationally-oriented

> features and functions that don't work as well if you insist on feeding it

> 'sheet data, as you've found!

> If you are doing calculations like you described, why not stick with Excel?

> Regards

> Jeff Boyce

> Microsoft Office/Access MVP

>

> "Majestic Eagle" <Majestic Eagle.ms-access.todaysummary.com.discussions.microsoft.com> wrote in message

> news:817EF8B9-F562-4847-BB9E-4C1CB10ADE4F.ms-access.todaysummary.com.microsoft.com...

>

>

All Comments

Leave a comment...

  • 1 Comments
    • Have you tried the update query I suggested earlier?

      Regards

      Jeff Boyce

      Microsoft Office/Access MVP

      "Majestic Eagle" <MajesticEagle.ms-access.todaysummary.com.discussions.microsoft.com> wrote in message

      news:E3713EB9-3F2E-4CFF-92A4-B3DFA1CD9BC8.ms-access.todaysummary.com.microsoft.com...[vbcol=seagreen]

      > Thanks again Jeff but you keep referring to spread sheets I am not using

      > spared sheets. I used Excel to put the information together the first time

      > so

      > I could make sure I had all the fields needed. I then entered all the

      > information on the products accordingly, and then imported this

      > information

      > in to a table. From there I made the Form so I could enter more data or

      > look

      > up products, change prices and so on. The form does all the mathematical

      > functions needed. When I add a new product it is added to the end of the

      > list

      > in the table. I now have over 130+ products. What I am trying to do is

      > clear

      > the first data field for each product.

      >

      > Qty Price Item Supplier

      > 2 2.50 product1 supplier1

      > 6 1.00 product2 supplier2

      > 10 5.00 product3 supplier3

      > 5 .50 product4 supplier4

      > And so on.

      > New products are added to the bottom of the list in the table from the

      > Form.

      > It also does my sorting. All I want to do is delete all the data in the

      > Qty

      > column and keep the data stored in Price, Item, and Supplier ECT.

      >

      > "Jeff Boyce" wrote:

      #1; Fri, 30 May 2008 20:49:00 GMT