------------------------------------------------------------------------------
--
The format is date/time
When i run the statement :

I am trying to create Outlook Appointments for our field staff from an
access query that is being pulled from our SQL DB.  I am using Visual
Basic.  I am getting the information to go to the correct place but
instead of creating a new appointment based on seperate values in the

could someone please help, is there a way of showing a zero in a query field
that shows a blank (empty) field.

I am creating a school locker database.  I am trying to create a report that
will list all the locker numbers and combos and then list the names of the
assigned students.  I would like the report to display the all the locker
numbers whether they are assigned or not.  I have ...

How can i export all saved queries sql into a text file or an excel file.

I'm using a Query Crosstab with 4 Column Headings: None, Low, Medium, and
High.  As long as I have each heading selected as an entry in the database it
will show and compute as a crosstab.  
My problem occurs if I am missing one of the data descriptions.  For

when I build a query in design view using query builder. I can see all the
criteria fields like field, table, sort, show, criteria, or but there is no
total found in that builder. I want to build a query with group by function.
I am not able to do that because of this.

due to a jet engine error (80004005)i have changed the date format in my db
from short date to medium, however, when i run a query the criteria (Now())
or <(now()) produces a data type mismatch error...please how do i fix
this?....

I have a query from multiple tables which records visits to patients,
hence a patient can have more than one visit per month or infact none.
I want to produce ultimately a report but I guess a query first which
will sum up all visits to the patients over the last three months.

Hi, hope this isn't a dog's breakfast to follow but I'm banging my head
against a wall here.  I've read & tried tons of your posts for the last 2
days on concatenating but am not finding my way yet (learned a heck of a lot,
though!!).

I have a cross tab query with a where clause.  I want the where clause to get
it's value from an open form using the syntax.
[Forms]![Client]![SolutionSelection]
This works just fine with a non cross tab query.  However the same

The following query is not sorting as required.  I am adding up cases shipped
out within date parameters and would then like to sort by number of cases
descending.  Any help is appreciated.
SELECT Items.Environment, Items.Item, Last(Items.Description) AS

I am working with a database that has date and time fields that are actually
text.  The date is inthe format yyyymmdd and the time is HHmmss (24 HR).  Is
there a way that can I put these two numbers together to perform date/time
calculations in Access and Excel exports?

I have a select query which is using the distinctrow  predicate to return
parent rows who's child rows meet the set criteria.
for example:
SELECT DISTINCTROW Clients.Client

I am trying to Rank multiple columns in a query.  I can Rank [Tpoints] field
with no problem.  What I am trying to do is that if the first field is equal
then use the [YTD Msn] field to detrmine the rank number and so on if the
second field is equal.