Deleting Information

  • Thread starter Thread starter Kbunch
  • Start date Start date
K

Kbunch

Hello.
I'm fairly new to Access and I'm having a problem. I have a database set up
that I need to "revise" each year. There are about 20 columns and most of
them need to be changed from whatever amount is in them to zero. I think I
can handle that. There are columns that have info. that needs to be
completely deleted so that other info. can be moved over (balance at end of
one year becomes balance at beginning of next year). Without deleting each
individiual "cell" how can I delete the info in that column. Also, how can I
move the info from one column to the next. Any help is appreciated.
 
Use an Update query.
It sounds like you are using Access as an Excel spreadsheet. A normal
relational database would have new records for the follow-on period.
 
Hello everyone

How is it going ?
........................................................................................................................................................................
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Subtracting multiple columns from another column 3
Excel Help to copy information from one row at a time to another sheet 1
Excel Need aid in Excel Formulas 3
Crosstab report for cross-month data 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
I need help on SQL 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
How do I copy a record from one table to another table in Access 1

Back
Top