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 (E-Mail Removed)> wrote in message
> news:817EF8B9-F562-4847-BB9E-(E-Mail Removed)...
> > 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.
> >
> >
> > "Jeff Boyce" wrote:
> >
> >> 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
> >>
> >> "Majestic Eagle" <(E-Mail Removed)> wrote in
> >> message
> >> news:23A420C9-E91E-4110-934B-(E-Mail Removed)...
> >> >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
> >> >
> >>
> >>
> >>
>
>
>
Similar Threads
