try this for accees

 DateDiff("m",[Date1],[Date2])

Try playing with this.

datediff(month, '04/27/2005', '01/05/2006')

I get 9 months and the dates are in US format but it should be a start

Here is another very good site.

http://www.w3schools.com/default.asp

Here is a website that we used. http://www.w3schools.com/schema/default.asp.  It is the best source for this area.

Also here is a sample xsd that we had to create for our vendors...

If any of the linked tables that do not have an assigned key in them are used in your update query, the query will not work.  All tables within an...

In Access, when you pull up the linked table in design mode, is the unique key recognized and marked as the primary key?

Do you by chance have an example. we started playing with the resolve method of the recipients yesterday but can not seem to get it down just right.  Thanks

it is defaulting to the current active directory.  This is the script we use to transfer files from DTS.  We use a LCD for the local machine with a hardcoded...

Personally, I have used Textpad for years.  It has syntax files that you can download to verify the commands that you are entering.  It can be found at http://www.textpad.com.  I...

We just recently went through this.  All we did was create the Access Tables in SQL Server with our naming standard but left field names as they had been named in...