Why use Access for your contacts? Try customization for one... (video)

re: Why use Access for your contacts? Try customization for one... (video)

Steven Thomas — Fri, 21 Jan 2011 22:33:56 GMT

MSZ: I'm not sure if this is exactly what you're looking for, but you can use the Format function, the Abs function, and the Date function in a formula with a date field to show the difference between values of that field and the current date:

Format((Abs([MyDateField]-Date())),"yy-mm-dd")

Format takes a value and formats it according to your specifications:

office.microsoft.com/.../format-date-and-time-values-HP001099015.aspx

Abs returns the absolute value of a number (which you want in case the subtraction returns a negative value):

msdn.microsoft.com/.../Aa262673

Date() returns the current date:

msdn.microsoft.com/.../Aa262709

However, this formula calculates the difference for year, month, and day separately - not combined. For example, if the two dates are 24 days apart and are both in January, the formula yields 00-00-24 (the years and the months are not different, and the days differ by 24), but if they are 24 days apart and the field value is in December, the formula yields 01-01-24 (because the years are different by 1, the months are different by 1, and the days are different by 24).

You can also use the DateDiff function to calculate the difference, but it yields similar results, and you'd end up using the Format function to get the format you want.

I think you may be asking for the number of elapsed days to be expressed in terms of years, months, and days. I don't know how to do that. I looked at using the MOD function and the IIF function, but ran into trouble because months and years don't always have the same number of days. However, my expertise is limited, and I'm not certain that it isn't possible. If this is what you are trying to do, you might try posting your question at Utter Access:

www.utteraccess.com/.../index.php

Hope that helps,

-Steven

re: Why use Access for your contacts? Try customization for one... (video)

Doug Thomas — Tue, 14 Dec 2010 17:16:42 GMT

Sergio: An Access expert here says:

It sounds like the customer wants to create a new 2010 database that includes the schema from their 2003 database but not the data. Here’s one way to do this.

1) Create a new, blank Access 2010 database.

2) Go to the External Data tab and click Access.

3) Browse to the 2003 database.

4) In the Import Objects dialog, select all the tables from the 2003 database.

5) Click the Options >> button and choose Definition Only (the default is Definition and Data)

re: Why use Access for your contacts? Try customization for one... (video)

Sergio Rivas — Mon, 13 Dec 2010 21:13:15 GMT

I have a database for my prior church, now I am doing my new church database, can I used the previous onAccess 2003? How can I leave only the skeleton without a data en the new version 2010?

re: Why use Access for your contacts? Try customization for one... (video)

Chris Downs — Wed, 08 Dec 2010 23:37:41 GMT

Cheryl: I'm assuming you already have a grouping level on the first letter of the name. Open the report in Layout or Design view, open the Property Sheet, and select the GroupHeader or GroupFooter section from the drop-down list. On the Format tab of the property sheet, you can set the Force New Page property to "Before Section" (in a group header) or "After Section" (for a group footer).

re: Why use Access for your contacts? Try customization for one... (video)

Cheryl — Wed, 08 Dec 2010 23:11:45 GMT

What do I need to do to print a report with a page break after each alpha contact name A, B, C, etc.

re: Why use Access for your contacts? Try customization for one... (video)

MSaadZ — Wed, 24 Nov 2010 18:38:43 GMT

Need an equation to calculate the deference between today date and another date in Access 2003, need the result showing as --year,-- moth,--day.

Thanks a lot.

M S Z.

re: Why use Access for your contacts? Try customization for one... (video)

Doug Thomas — Wed, 24 Nov 2010 15:40:14 GMT

Kathrin: You can try Access and other Office 2010 programs for 90 days: office.com/.../FX101868838

--Doug

re: Why use Access for your contacts? Try customization for one... (video)

Kathrin — Tue, 23 Nov 2010 19:10:15 GMT

Does anyone know if I could get a trial version of Access to find out if this software suites to my needs? I would like to play around a bit before I purchase.

Thanks,

Kathrin