I am stumped as to why the below query is not functioning correctly.
SELECT tblTempAD.*
FROM tblTempAD
WHERE  tblTempAD.Arrivals  Between [forms]![fConsecConfo]![StartDate] AND

My mailing list often has two last names for a given address.  Each is a
separate row in my database. I want to be able to make an address label that
says "The Smith & Jones Residence".  How do I write a query that will pick up
both last names for a given address  (the address is ...

I have set of queries running for employee performance ranking culminating in
a final query that shows their name, employee ID and overall score, i would
like the final step to also add a column with rank, so the person with the
highest score has a 1, next highest has a 2 etc.... ...

I have been plagued with problems over the years when trying to get the
parentheses right for the following:
Table A:
A_ID - PK

I have 47 union queries that collect data for 47 pumping stations on monthly
basis; then plots each query result.  Every month a table is added to the
list of individual union query.  I got tired of adding the union select
statement manully to 47 queries and started to write a ...

I have set criteria in a query to pull 9 specific names (no matter how many
times they are listed) from a field in a table. I also have a date criteria
to choose those records only from 2008. (1/1/08-now)
My problem is my query will pull all records containing those names but also ...

I have a set of products that are published annually where i need to track
the currency of the products as a statistic. (ex. 10% are 1-2 years old, 20%
are 2-3 years old, etc.)
The database stores the date of publication. How can I use a query to assign

using A2k;
seen LOTS of posts about this topic, but none seem to address the
heart of my question.
Let's break this into 2 parts: queries (stand-alone); and form data

I would like guidance producing a query statement that will count the number
of times a particular name appears in query/table. I have created a query
from a table to on display the necessary fields for output. For instance, I
would like the Top 10 Institutions Names from my ...

I have a summary query that is summing the daily% [Sum of Daily%] and
summing the hours [Sum of Hours].  When I run the query with these two
columns, it runs fine and shows the values.  I add  a third column which is
calculted as Rate%: [Sum of Daily%]/[Sum of Hours].  When I run ...

I have built a filtering system for our sales order modeled after Allen
Browne's Search procedure (http://www.allenbrowne.com/ser-62.html).
Some of the criteria are applied to the forms filter, and others to the
forms recordsource.

I am trying to append data from tblitemline to tblitemlist. I only want to
append new records. The unique field is ListID. I want to append 4 fields
total. I can't get it to limit it to new records. Any help would be
appreciated. Thanks!

I need to turn the following into a queries where I get the top 'x' values
for each Officer based on their hours, not the top values for the whole
dataset. Can anyone help please.
Regards.

The following query IIf([Subject]="holidays",[SumOfNon Chargeable],"0")
provides  the value of the non chargeable field which originates as a number.
The query returns the correct value but returns it as text and not a number,
how can I rectify this?

i have a form with a multiselect list. i want my query to return records
based on the multiple selections. how can i achieve that?
i have tried [forms]![formname]![listname] but i get no data.