SQL in VBA

Resolved · High Priority · Version 2003

Thu 4 Sep 2008, 15:57 Delegate Gillian said...

Gillian has attended:
Access VBA course
Excel Advanced course

SQL in VBA

Should many SQL queries be called upon one after the other in VBA? I no longer want to do many Access queries manually. There are about 15 queries to do one after the other on a table I am analysing.

Wed 10 Sep 2008, 19:57 Trainer Laura said...

RE: SQL in VBA

Are all the 15 queries action queries?

I don't see a problem running one query after the other in SQL in VBA if they are action queries.

If the queries are all based on each other so it would be one very complex SQL statement combining all the queries that might be a different matter just due to the complexity of the SQL.

Laura

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

View all Access hints and tips

SQL in VBA

SQL in VBA

RE: SQL in VBA

Access articles

Access tip:

Calculating The Difference Between Dates