I have many queries that append data to a table.  One of these queries is a
query named: qryAppendCOS.  This query appends data to table.  Within this
query, I would like to be able to append the queryname "qryAppendData" to a
field, for all records that it is appending.  I want ...

I have the following query.  It selects a degree, salary range and
graduation date and sums the count of those combination of values as a
group.
SELECT D.degree, E.salaryRange, P.gradDate, COUNT(P.degree) AS [Count]

Before I proceed down a long path, I was wondering if anyone could clarify a
couple things for me.  I usually work on SQL server, and I'm not trying to
manipulate some data in Access.  Does Access have 'left outer join'?  or
just outer join?  What is the difference either way ...

I have a shared database with over a hundred queries in it. It is getting
difficult to determine if a query already exists.  Is there a way to find a
query by searching the name of the query?

Can someone explain what this is?  I have tried to find answers to my
questions first by reading through other people's questions.  I keep seeing
this and have no idea what it is.  Thanks.

This is a continuation from last weeks posting regarding this question.
I managed to solve some of the problems in that I had a table appearing
twice in the relationships window, therefore I was getting a duplicated
statement. However I still cannot work out why the following ...

I am trying to use the "like" statement with a variable in the criteria of a
query.  
I am using something like this, but not working.
This works, but I want it dynamic

I have a simple query connecting employee details to their contract
information. Why is this not an updatable query? It is a one to many
relationship - an employee can have many contracts.
Can anyone explain simply to me why this cannot be updated? What can I not

Access XP, Windows XP
Hello,
I have a select query which uses a combo box on a form as its criteria.  The
name of the form is frmSenateReports.  The name of the combo box is Combo37.  

I would like to exclude the following 3 values from the query result, using
the criteria with a NOT.
#, 29 and 60
I have been successful with the use of:

Is it possible to create a query that calculates difference between two
Business Days excluding weekends?  I've seen the posts, and it all involves
VB code?
Thanks

How can I limit the number of enteries a query creates in a table?
Table has about 1000 enteries.  I only want to work with 50 at a time.
Thanks

I have linked two table from excel database. What i want is the data from
both table in one table but i am not getting data i want. Once i run the
query it gives me to many data which duplicate (there are 2 data in both
table so new table should reflect the only 8 data but it is ...

How is an Autonumber (Incremental Number) assigned to a field when using a
Make Table query.

I need to set up a query that retrives the top ten results of the most
recent dates entered.
My query currently looks like this.
SELECT TOP 10 tblCase_File_Status.CFID, tblCase_File_Status.SCD,