Deleteing specific cells in a record

[Aaron]

Hello

I built a database application in Access to print the labels for my company's products. It basically consists of two main tables, and a variety of forms, queries, macros, and reports for the various labels the user needs to create. The first table holds new label information that the user enters. Once all the label information is entered, and the proper labels (reports) are printed, the data is copied to the second table for perminant storage. Then, all of the data in the first table is cleared. I have also set up a form to search through the second table for existing labels (for reprint purposes) to print a specific label in a set. The second table (that stores all label data perminantly) has two extra fields as to specify whether the label has a "red border", "blue border" or "no border" (1st extra field), and whether the label is an "arrow label" or a "serial number label" (2nd extra field). Based upon the information given in the form, my programs knows what query to use and then which report to use

My question is: Is there a way to create a macro to delete on specific cells in each record, but not the entire record itself? My appologies for all the background information; I supplied it in case it would help illustrate what I am trying to do

Thank you in advance for your hep

Aaron

 

[Elwin]

'Update' queries are intended to do exactly what you've
described. Just specify NULL as the 'Update To' for the
fields you'd like cleared.

-----Original Message-----
Hello;

I built a database application in Access to print the

labels for my company's products. It basically consists
of two main tables, and a variety of forms, queries,
macros, and reports for the various labels the user needs
to create. The first table holds new label information
that the user enters. Once all the label information is
entered, and the proper labels (reports) are printed, the
data is copied to the second table for perminant storage.
Then, all of the data in the first table is cleared. I
have also set up a form to search through the second table
for existing labels (for reprint purposes) to print a
specific label in a set. The second table (that stores
all label data perminantly) has two extra fields as to
specify whether the label has a "red border", "blue
border" or "no border" (1st extra field), and whether the
label is an "arrow label" or a "serial number label" (2nd
extra field). Based upon the information given in the
form, my programs knows what query to use and then which
report to use.

My question is: Is there a way to create a macro to

delete on specific cells in each record, but not the
entire record itself? My appologies for all the
background information; I supplied it in case it would
help illustrate what I am trying to do.