i am using the calender to fill in a date field but have found a need to have
a search done to see if that date is used all ready.   How do i add the
search part to my calender.

 basically i have a query that pulls about six different totals from
another query and is "suppose" to add them all together. Ive tried setting
the "Total;" method in design view to "Sum" the column but its WAY off. Ive
also tried creating an expression which returns the same ...

Using Access 2003 in 2000 format.  I am finishing up my query and am stuck
on an expression to give me the total days my patients are on a ventilator.
For this calculation, the time the patient went on and off the ventilator
doesn't matter.  If they started on it on 1/1 at 11:30 ...

Folks,
I extended the SQL below (original SQL designed by a user from this
newsgroup) but it always returning a the error msg "the expression you
entered exceeds the 1,024-character limit for the query deisgn grid".

I use the following to calculate overall placement in a sporting event but it
produces ties that are not acceptable.  the powers that be have decided to
use 'Score' to break all ties.  
Rank: 1+DCount("*","tblRecapB","[Fee Id] = " & [tblRecapB].[Fee ID] & " And

I have a query where I want to set the criteria on a text field to look for
the results in a field on my form.  The form[frm_WSearchData] field is called
description and has been formated to contain multiple words.
For example:  The description field reads: "*pump*" and like ...

I'm stuggling with how to list a range of record numbers for an update query
in the criteria field.  I'm trying to update the VehID to "1" for records  10
- 35 in the TravelerID field.  I have the upate query and have 1 in the VehID
"Update To" filed but having trouble with how ...

I have a table which has an E-MAIL field.  I would like to select all those
e-mail addresses that are ??????@aol.com.
How can I do this?

Here is problem:
I have table with buyers, they are buying in two separate shoops, and are
paying it trough compezation- to me. So I have two diferent tables, forms
where I record their expenses and one table with their id, names..., one

I have a word merge, trying to merge from my field 'GENDER' which
holds the either Male or Female.  In the word document, I have to ask
the question twice.  I have an M  and an  F and want an X to show up
next to the proper letter.

I have the below query, I have copied the SQL..
I want this query to show the Top 3 Cost Centres with the Highest Spend by
Business Unit Names.  EXAMPLE FOLLOWS:
Business Unit 1  CC123  £76000

I have a form that displays in tabular form a table.  The form footer
contains a textbox that sums the 'amount' field.  I want to add another
textbox that displays the sum of the 'amount' of a query of records where
another field is queried.

I have a very simple query looking for a date in a file, I ran it and it
worked, I then cut and pasted the SQL into my VBA code (turning it into a
string etc.) and it didn't work. I then noticed the date in the SQL was
wrong, so I went back to the original query and I noticed ...

My database needs a record entering for every working day. A working day is
defined as every day from Monday to Friday. This includes Bank Holidays and
other holidays, so at least that bit isn't a problem
Can anyone think of a query that can check if any days are missing? eg one

I have a qry where I pull records from a table.  When I run this qry all is
fine,  I get the bound column (1) returned which is the text I want not the
primary key which is in column(0).  
I do the same for another table... all is fine.  Note these 2 were created