I need to enter the date and time into a DateTime field in my Access
database. I know how to enter just a date, but how do I enter a date and
time together? I could not find anything in the help file or on any
websites. Could someone let me know the syntax for entering a date and ...

An example of a fixed time period would be July 1, 2005 or Q1 2005, Q2 2005,
etc.  Examples of relative time periods would be 12 month rolling to Current
Year, Current Year, Last Year, YTD Current Year, Current Quarter Current
Year, Previous Quarter, 12 month rolling two years ...

I have seen that on a table given by a query that groups and count
records with field of same values, is not possible to modify a valu
although the field property writes that it is not locked.
Is possible to edit a value on the table and have this value passin

I have a query that calculates commisions paid from an install date up to 91
days after the install date. How can I calculate the commision for a
particular sale up to the 91 days and continue to be in the query results
after the 91 days with no commision calculated. Basically ...

What I want to do is have a macro that is called by a button or link in a
field on a table.  this will be a generic macro that will get the value in
the "record id" field of the record the button pressed is in, and feed that
value into a query.

In the code below, does each line execute before the next begins?  If not,
do I need to put some kind of command that makes it wait?
Private Sub Form_Open(Cancel As Integer)
CurrentDb.Execute "uqryStartDateCurrYear", dbFailOnError

I gave up on the reports group because nobody answered. I am therefore
thinking it might be an impossible task in reports to create a report to
look like a spreadsheet.
Perhaps the data can be created with a query which then can fill the fields

I have the following Loop.
The [Test] is a field with numbers in the field
1 to 20.
The txtTest are fields on a form

In the criteria section of a date record I want it to create a parameter
between two dates.  I have input the simple equation:
Between [Enter Start Date] AND [Enter End Date]
How can I get the second field to generate automatically generate 14 days

One of the strangest things I come across.   Tested fine on my workstation.  
Executed the same macro on another workstation which has the same version of
ACCESS 2000 (9.0.2720) and ran into this error "Function is not available in
expressions in query 'RIGHT([tblname!fieldname] ...

I can not find this dialog box....I'm trying to dedup a large database and do
not want to have to do it manually.
Help says, "2. In query Design view, click Query Type (okay) on the toolbar,
and then click Append Query....I don't see any Append Query to click!

I have a query with an alias like this:
SELECT [Dollars] * 0.5 AS [Total]
The "Dollars" column is formatted as currency, but after this query
"Total" displays as integers. How do I make "Total" be a currency field

I made two queries.. Query A works, but Query B dosn't.
A, is supposed to pull somebodies information when doing a search by
department name. It can also pull stuff up by an alternate department name.
the keys obviously are deptno.

Ive been making an asp page that uses WHERE something LIKE "%text%".
this has been working fine. when i copy and past the same exact thing
into access it just returns with no results.
I do get the propper results if i change the %'s to *'s..

I'm trying to use the "Right" expression to take a piece of information from
one column of data in order to create a new column, but it's not working.  
Any suggestions?  I'm trying to insert state abbreviations that are already
listed in a CITY_STATE column into a new column.  ...