Delete data from one column only

M

Majestic Eagle

I have a table with 8 columns lets say (A-H) there is data in these columns
consisting of 128+ rows. All I need to do is delete the information in column
"A" only while keeping the data stored in columns ( B-H). I would like to do
this by adding a button on the form is possible.

Thank you
 
J

Jeff Boyce

First things first ... BACKUP!

Now, create a new query in which you update the value of that field/column
(by the way, Access is NOT a spreadsheet -- you'll want to stop thinking
about "columns A-H"!).

You can add a command button to your form that runs that update query.

Now, why? As in "why do you have a table with rows of data for which you
feel the need to delete the contents of a single field ... repeatedly?"
What are you doing with that table that requires this?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
M

Majestic Eagle

Thanks for the reply Jeff.

First off columns (A-H) are for example only instead of filling up a lot of
space with the actual Field names. What I did was created a spread sheet then
imported it into access. I then built the form accordingly with all the
mathematical formulas.

Column “A†stores the number of items ordered then the rest of the
mathematical and sorting is completed. I need to delete column “A†so that
the mathematical formulas revert back to zero when ever it is needed. Column
“A†data changes from order to order. The rest of the fields do not.
 
J

Jeff Boyce

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
 
M

Majestic Eagle

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.
 
J

Jeff Boyce

Have you tried the update query I suggested earlier?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top