I'm not getting the right syntax and I need help. gstrDate is a global
variable.
=================================
strSQL = gstrDate & " Between #" & Me.BeginningDate & "# And #" &

I have a table with two columns. Each is a column of numbers, any
numbers. Like this:
Col1   Col2
1       8

As the expression: =Format(Now(), "y")  displays the number of the day of the
year the current date represents, where y is 1 through 366.... I need the
antonym funtion of this, in order to get a date from a specific number of
seconds given.

I have linked several tables to a database  called sondb on the SQL server
called orlapp.  I have used a DSN called MYAPP with userid and password of
"monthly"
Once I open the database and run my query I have to sgn on using the user id

I am trying to replace chars in field without replacing all the chars.  I
have a field called in Member TBL called MbrName with a value of BFL####.  I
need to run a query that promps for a user number and have the #### replaced
with the user number entered.  I can only get the ...

My conference program database includes presenters and presentations.  Some
presenters do more than one presentation and some presentations have more
than one presenter.  I can select unique records by setting the query
property for unique value to yes.  It works for mailing ...

I KEEP GETTING THESE ERRORS 湡慣桳物  IN MY DATABASE AND THIS ERROR MESSAGE
APEARS WHEN I TRY AND DELETE THE RECORD OR FORM the search key was not found
in any record

I have a query and a report using the query that I need help getting totals
on.  The query gets records from several asset protection tables involving
theft, etc.  There is 1 record per case # for each suspect involved in the
case, so each case # could have several suspects.  The ...

When I use a date-parameterised query in Access 2000, the data returned from
my Memo-type fields in the queried table is truncated to 255 chars.
Is there a way to fix this so that all of the characters held in the memo
fields can be returned by the query and subsequently displayed ...

My database has data summarizing reports.  Each report has a
designator, and each report has the potential for multiple codes within
the "type" field.
I am running a query to feed a report.  The search criteria for the

Hi...
With the help of Mr. Foster I have created a expression as follows.
SELECT A.FlightDate
FROM [Year2005 Pilot Info] AS A

I have a report that pulls from Query1.
Query1 pulls from 6 queries (A through F).
There are times when one of the A through F queries will produce no records
(which is correct), but this causes Query1 to produce no records since one

e.g. 11:00:00 AM to 11:59:59 AM how to sum into 1 hours

I have 2 columns that I want to return a single list of unique values.
I'm using the query in a combobox of a form.
example
Table 1

Show last record but grouped via the data I.e.
Call Sign  TIME
TT1         12:00
TT2         11:59