How to CLEAR a field's content (2) ?

  • Thread starter Thread starter Martin
  • Start date Start date
M

Martin

But, I don't want to EXPORT it, I only want to sent the whole Access files
to my sub-company just without the content of this field.
 
Martin said:
But, I don't want to EXPORT it, I only want to sent the whole Access
files to my sub-company just without the content of this field.
Click to expand...

Then make a copy of the file and before you send it run an update query against
the table.

UPDATE TableName
SET FieldName = Null
 
Thanks!

Rick Brandt said:
Then make a copy of the file and before you send it run an update query
against the table.

UPDATE TableName
SET FieldName = Null
Click to expand...
 
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

How to CLEAR a field's content ? 1
How to Export Gmail Emails to PST Format? 6
Field content auto generation? 7
Combine the contents of a field so only one row is returned 4
Windows 10 Changing folder view settings to a folder and sub folders but not contents. 3
How to Convert EML to PST? 2
How to unlink TOC from a doc 0
Zero fill numeric field 1

Back
Top