Access

Resolved · Low Priority · Version 2003

Tue 20 May 2008, 16:37 Delegate Juliette said...

Juliette has attended:
Excel Intermediate course
Project Intermediate course

Access

How do I dedupe two files

Sun 13 Jul 2008, 08:42 Edited on Sun 13 Jul 2008, 08:45 Trainer Pete said...

RE: access

Hi Juliette, Thank you for your post.

In answer to your question; Depending on the size of your database it could be not that straightforward to dedupe (remove duplications), however there is a propriety piece of software which will undertake this task quite easily for you, As this is third party software no responsibility for this software is accepted, however I would recommend that you only try this on a backup of your database, until you are satisfied with the results. The website is www.winpure.co.uk have a look and see for yourself, there is a demo version which you could try out.

regards Pete

Training courses

	98.7 % recommend us
	More live stats...

Training information:

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