How would I add a date to a stored date. For instances... I have a log table
that has a bunch of dates I want calculate another date in an upcoming date.
I basically need to know how to input a dateadd formula in a controlbox or
in a query criteria. I know it's DateAdd something. ...

Just downloading Groove now.  Was wondering if it has a database mgt tool.  
If so, do you recommend Groove or Access?  Starting a small business.  Max
leads will be 10,000/year.  Max clients 1,000/year.

I'm looking for a letter to provide to new employees due to
merger/acquisition - does anyone have an recommendations?

I have a 2003 database which has worked fine until recently.  I have made NO
design changes or changed anything in any way.
In my Tables & Forms, when I opened some the other day, some of the
drop-down, linked fields had some blanked-out columns.  The table that it's

I need to extract just the date portion of a date/time field in order to
compare with another date field to calculate number of days between the two.
Can someone please assist with how I go about getting the date only portion
from the date/time field?

On many websites I visit, I get the message 'there is a problem with this
website', even though it is a well know, safe site, as in bank, government,
etc.
I wrote one of the companies and they said there site was safe and offered

Could anyone help me - Im trying to covert text to date.
The text represents a date in the format of year, week and day of week e.g.
2007421 (yyyywwd ?). Sometimes the day is not indicated.
I would like to convert this text to a date. If the day is not indicated, i

I'm creating a query. The query is to find all invoices that are over 14days
old that havent been paid. I can get the list of unpaid invoices fine but the
problem comes when i try to get just the invoices which are over 14 days. Ive
tried [invoice date]+14 and [invoice date]>14 ...

Is it possible to put more than one criteria in a query? For example; I have
a query to separate teams, I want to show two or more teams together. I'm
sure this is possible. I just don't know what to use to sepatate them.

Thanks in advance for your help...
I am running an update query out of VBA by putting the SQL in a string and
using the DoCmd.RunSQL feature. In particular, I am trying to remove a value
from a date field in a table, without deleting the record as a whole.

I have a database created in Access 2000. When I try open it in Access 2003 I
get the following error. "Your database or project contains a missing or
broken reference to the file 'MSDWCF.DLL' Version 1.0" The database
eventually opens, but some of the forms will not open from ...

Hi
I have the following SQL code for a query
SELECT Session.Name, Count(Session.[SO Number]) AS CountOfSO
FROM [Session]

I am trying to pin down a good setup protocal when using ADP in a Citrix
environment. I have searched the internet but seem to get contradictory
advice.
What would be the best setup for mutiple Citrix users using ADP. At the

I've set up a relationship between tables, however when i click on the cross
to expand the record and see the linked table I get this message.  It now
wont reverse.  Please help.
The table or query name 'Sheet1' you entered in either the property sheet or

All,
I am using Access 2000 (would love to upgrade but isn't going to happen
anytime soon!)
When i'm not too busy, i like to take a copy of the database and play around