I have a query with several fields that I need to pull out certain
information from. The fields are all expiration dates for various items.  I
need to show all data <= certain dates, but unless all fields meet the
criteria the query comes back blank.

I came up with this crosstab query which gives 8 days worth of
data.However, if
my database has only 6 days of data and 2 days in between are blank,
this query

I'm in need of some help with a query and would appreciate any help I can
get.  I'll try my best to explain the situation.  I have a database that
tracks sewer overflows, in this database I have a table called "CSO Overflow
Visual Inspection" which has a few relationships to ...

In attempting to create a simple query I came across an unexpected
occurrence.  All I wanted to do was create a select query that I could narrow
down to returning results by entering a date range.  So using the between and
operaters I decided to have Access create a pop up ...

I have the SQL used for the RowSource of a Graph object in Access.  It is
currently sorting by personnel (ascending order).
I would like to sort it in descending frequency order of personnel.   Can
someone please help.

Okay, I tried reading the other average posts, and I still can't figure out
what to do. The database I am using tracks when various lots were received,
when the lot went to department A, and when it left department A. Therefore,
the table has a lot number, and 3 dates.

I need a method of excluding data from a field in a query.  One of the
columns lists several different item codes and I want to exclude 3 of the
codes.  How can I perform a 'not equal to' for more than one code?

I have re-created a db and cant get the queries to work right.. My tables are
Main   Ven   and Description. In the before db I had a query that has this
sql statement..
SELECT Main.Rig, Main.LeaseName, Descriptions.[1Category], Sum(Descriptions.

DLookup("[Code]", "[Codefile]", "[County] = '" & [County] & "'" works just
fine, but I need to also compare [State] with [State] because different
states have the same county name. I tried adding AND logic, but I must not be
doing it right. Help?

I have 2 tables with a common field "server".
Table A has the following fields:
server
status

I have the following query to run a report of parts for production. If a
product requires 2 doors the part appears twice - same [UniqueIDInJob],
[Width], [Length], [Depth] but the [PartID] is unique and sequential. If
[Hinging] = "0" I need a field on my report to show "L" for ...

I have twelve columns.  In each column, I use an expression to calculate
revenue for a month.  Is there a way to add another expression that sums
certain columns?  Basically, I want to add a subtotal every three months for
"quarter" total and then sum all twelve of the columns ...

when I make an append query, the results are shown multiplicated, how can I
avoid this?

Hello -
I have a bunch of data that looks like below:
Data
1

From a dataset I retrieve customer names and the products they have
purchased:
client name product name
client 1    product a