Update Query!

[Bob Vance]

Can I have an UpDate query to delete all content of all fields in
tblHorses
tblOwners
tblInvoices

 

[John W. Vinson]

Can I have an UpDate query to delete all content of all fields in
tblHorses
tblOwners
tblInvoices

You probably need three queries, one for each table. They can be run in
sequence from a Macro or from VBA code.

If you have cascading deletes set up on the relationships between your table -
e.g. tblHorses is related one to many to tblOwners, with the Cascade Deletes
checkbox set, and similarly for tblInvoices - then deleting a record from
tblOwners will delete all the records for that owner from the other two
tables. It won't "delete the content of the fields" - it will remove the
entire record leaving no trace that it was there.

(Be sure you have a backup!!!!! Deletion is a one-way street!)

 

[Bob Vance]

Well actually I have 25 tables and want to delete the contents of 20 of them
to form a empty database that my friends can use without my data in it, so i
should still look at cascade delete...Thanks bob

 

[John W. Vinson]

Well actually I have 25 tables and want to delete the contents of 20 of them
to form a empty database that my friends can use without my data in it, so i
should still look at cascade delete...Thanks bob

There's an easier way!

Create a new empty database, and use File... Get External Data... Import to
import all 25 tables. For the ones you want empty, check the box "design view
only"; for the rest, check "structure and data".

 

[De Jager]

Can I have an UpDate query to delete all content of all fields in
tblHorses
tblOwners
tblInvoices

 

[joelgeraldine]

yj;:!§

 

[joelgeraldine]

ykkklmmmmùùùùù**

 

[matteo]

Can I have an UpDate query to delete all content of all fields in
tblHorses
tblOwners
tblInvoices