I am using Access 2003.  While in Design mode, my append query works when
clicking the Datasheet View.  However, it gives an error message about an
unknown fieldname when I click this query from the list of queries or from a
OpenQuery Macro Action.  Help.

I have an access query that I run on a regular basis but that doesn't
always sort. It sorts most of the time, but once in a while it won't,
which makes it really annoying and impractical.
Does anybody know why this is happening?

I am having problems with a comparative query.  I have the following table:
[Tbl_Commission]
    [Sales Rep]
    [Manufacturer]

Hi guys, please forgive any use of incorrect terminology, i am a bit of an
access newbie.
Below I have constructed an example of the problem I am having. My db does
not have any relationships defined and contains the following tables.

I must be missing the obvious here...so go easy on me...I need to
query 8 fields that have the same name w/ a numeric extension.  I
don't want to create 8 queries unless I have to...The actual record
set contains constants in terms of data entered...here's my generic

I have the table
Table Herd
IDUT                                 Autonumber
CodFarmer                         txt

Boy, I need someone's help.  I was asked to give the President an average #
of years our employees have been employed.  We have 671 employees.  We have a
field called DateIn which is there hire date.  I'm trying to come up with an
expression where it will take today's date and ...

Hi.  I'm confused and just can't seem to grasp how a 3rd table would result
from:
Table 1 = Employees and employee info
Table 2 = Procedures and dates completed(there are 500 different procedures

I have created a "Make table" Query and saved it, but when I go to run the
query, Access instead of saying it wants to delete the table before running
it say it wants to delete the QUERY?  and it does then it gives me a an error
that there is not data  to run, any clue?

I know the command "CurrentDb.Execute "INSERT INTO [Input] ([Loc_Desc])
VALUES (""" & Me.List12 & """)", dbFailOnError" works.   I now need a way to
delete a value from a table using a similar command.  I am wandering if there
is a "REMOVE FROM" or something similar that will take ...

I have a front/end and back/end MS Access databases that I am connecting via
ADO.
In the f/e I am issuing a query containing LIKE statement. The very same
query works fine when issued in the b/e Access mdb.

I have a field named invdate.  this field data shows as 1/01/2001.  how can i
write a query to add a leading zero to this date field for the months of
january thru september that will display the field as 01/01/2006?
thanks for your help,

Hi, in my query design view, I type in "Month(4)" for my date field in
order to get records that were recorded during April, and I know that
there are many that have been done in that month, however the query
returns no records... What am I doing wrong?

I am getting syntax errors when trying to use the SELECT DISTINCT predicate
in my query.  Has anyone had any success getting this to work properly, and
if so, what is the correct syntax.  I have tried to work with this for three
days now and have had no success in using this.  ...

I have three multiselect listboxes.
I have coded them in VBA to pull the selections and then open a report (that
has an underlying query) using the WHERE property in the openreport event.
One problem was that my WHERE property has "OR" between each code for the