(my computer hiccupped when i tried to send this a few minutes ago so this
may be a repeat)...
i have a table (actually it's a query) i'm using as a source for this
current query.

I'm using a VB Command to change the SQL statement on my Query
qry_SEARCH
On the main form, frm_SEARCH,  I have a sub form sfrm_SEARCH bound to
this Query

I have the following union query:
PatientID    EventDate    BodyWt    DailyDose(ml)    Frequancy
004320        3/26/1996           64       
004320        3/27/1996                             20             6

I have a table that stores peoples holiday (vacation) info. There is a start
date and end date... thus calculating a duration. However, I want to create a
query that will be the source for a report that will return the total number
of days off that people have had. eg

I have many questions, about a project I'm doing. It is a project for my MIS
class at school and it is a MAJOR portion of my grade. The main problems I'm
havin is in relation to the criteria for displaying records, some in
conjunction with the parameter feature. If there is ...

why can't i enter data when i join three tables in a query that are joined?

I have a query with this year data and last year data. Without deleting last
year data. How can I only show this year data by writing an expression?
I need an expression that will change on it's own 12/31/05 to 1/1/2006.
Floyd

I have a table that has fields such as date, Invoice#, salesrep# and sales
margin dollars for every product sold listed in a Invoice. I would like to
populate a crosstab query preferably as follows.
Group by Salesrep as row

I have a pretty basic select query.  The user types in the "Rig Designation"
and a list of all projects utilizing that rig are displayed in date order.  I
would like to include an option that will display all projects regardless of
rig or all records with no rig (null value).  I ...

I am importing a text file into a Access table and I have a postal code
field that contains Canadian and US postal codes. The field is 7 characters
long and I am importing it as a text field. The Canadian date looks like
this: A0B 2J0 and the US looks like this: 834020000 I need to ...

This is probably a beginner question. However, I have the following query:
SELECT tblPROJECTS.Projectsymbol, tblPROJECTS.Title, tblPROJECTS.StatusDate,
tblPROJECTS.Budget, tblPROJECTS.Status, tblPROJECTS.Region,
tblProjectSubject.SubjectName, tblPROJECTS.ProjectID

I need to pull back a few field from a table. I need one of these fields to
be DISTINCT, at the moment Access is looking at the full record as DISTINCT
not just the one field that I want.
What am I doing wrong??

SELECT E.BranchID, Branch_TBL.Branch_Desc, Branch_TBL.BranchCategory,
Count(E.BranchID) AS CountOfBranchID, E.EffectiveDate, E1.EmployeeID,
E.Action_Abrv, E.Status, E.EffectiveSequence
FROM Branch_TBL INNER JOIN

I'm relatively new to Access and I have a question about doing calculations
for fields where they may or may not be null values. I initially had all the
blank records default to 0, but then I got Overflow errors, so I reverted
them back to blank null values.

I have a database that has multiple tables and would like to do a few thing.  
First off all of the tables have the same colums and layout.  What I would
like to do is create a query that get a user input, looks at the data in all
of the table and give any rows that match that ...