Multiple sql delete

Resolved · Low Priority · Version 2016

Thu 27 Sep 2018, 10:34 Delegate Manny said...

Manny has attended:
Access Intermediate course
Access Advanced course

Multiple sql delete

hello guys,

Looking to delete lots of test data out of my database. I have written a basic SQL query but it is not running? Syntax error?

DELETE * FROM ABST
DELETE * FROM NAVT
DELETE * FROM PositionT
DELETE * FROM PricingT
DELETE * FROM XoverT;

I dont want to delete the table or lose its struture, just wanted to emtpy the data. it works if i write a query with one line, but was hoping i could do this all in one go?

Manny

Thu 27 Sep 2018, 13:16 Trainer Jens said...

RE: multiple sql delete

Hi Manny,

Thank you for the forum question.

Try this:

DELETE * FROM ABST;
DELETE * FROM NAVT;
DELETE * FROM PositionT;
DELETE * FROM PricingT;
DELETE * FROM XoverT;

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Thu 4 Oct 2018: Automatically marked as resolved.

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Access tip:

Calculating The Difference Between Dates

If you wish to calculate the time between two date fields, this can be done in a number of ways:

1. As a calculated field in a query
2. As a calculated control in a form or report
3. As a calculation in a VBA procedure.

The basic syntax to get the number of days between two dates is:

=[One Date Field] - [Another Date Field]

You can also use one of the following functions:

=Month([One Date Field] - [Another Date Field])
which calculates the number of months between the two fields

=Year([One Date Field] - [Another Date Field])
which calculates the number of years between the two fields.

Another function is the DateDiff() function.

It uses an argument to determine how the time interval is measured. For example:

=DateDiff("q",[One Date Field] - [Another Date Field])
returns the number of quarters between the two fields.

Other intervals that can be used in this expression are as follows:
"yyyy" - Years
"m" - Months
"d" - Days
"w" - Weekdays
"ww" - Weeks
"h" - Hours
"n" - Minutes
"s" - Seconds