A report in my database has been working perfectly until today.  No changes
have been made to the report or the queries it is based on, but I am now
getting a "too complex to be evaluated" message.
The SQL for the query tied to the report is:

Wrote my first little bit of SQL code tonight, successfully created a union
query.  (It's only two lines, but hey I'm proud of it.)
It works just fine as a select query, but when I try and make it a
"make-table" query, I get the error message

Hi, fairly new at this....I have 6 files from 6 different plants. The field
names are all the same for each, and I want to make one table that is easily
updated as the 6 different tables (in Excel...linked into the Access Database)
are updated.

I have two tables. The first table includes a paycheck date.  The other table
includes pay rate data and assigned job data with multiple start and end
dates for each time there is a rate or job change.  I join the two via the
clock field (employee number).  If the check date ...

Can someone please tell me why this query isn't working correctly:
INSERT INTO workingnew ( meter_number, meter_name, prod_date_time, meas_dth,
meas_mcf, BTU )
SELECT dbo_meterset_volume.meter_number, dbo_meter.meter_name,

How can I trim the "-" in the following:
Liner: [OutsideLinerWeight] & "-" & [1MediumWeight] & "-" & [2LinerWeight] &
"-" & [2MediumWeight] & "-" & [3LinerWeight] & "-" & [3MediumWeight] & "-" &
[4LinerWeight]

I am trying to count records in a query. The ield is a yes/no fied and I want
to count the number that are no. I just can't seem to find it. Thank you for
your help

I need to combine the text in the same field of multiple records, grouped by
another field, to turn out a report showing only the grouped data.

We apply and sales products.
I have a table that has the products info and a table that contains how much
we sell and what we have applied.  Other table that shows how much product we
purchased.  The products we use come in gallon or pounds.

I have 2 tables that I need to query.  One is a customer order table where
many customers can have the same item on order for various dates.  The other
is a production table showing what we have in production.  Again the same
item can appear more than once coming in on different ...

Here is the scenerio:
I want to run a query which will me a list of all employees eligible for
401-K enrollment as of last pay period. The criteria for eligibility is as
follows:

I would like to join two queries into one. Can this be done using a union
query? The queries have some related fields but the majority are not. One
query has 6 fields and the other has approx 9 with 3 being the same field
name but non have the exact amount of records. Both are ...

I have a query set up that will display all my netsales data for the month. I
want to further break this down to show the sales for the day. I looked at
the SQL code and was trying to break it down a bit, for the monthly data it
looks like this:

How do i allow users to change the top value number in a query without going
into the design mode?

I have a query that displays sales by day of week, however it only allows me
to display the days in alphabetical order (Friday, Monday, Thursday...), as
opposed to chronological order (Monday, Tuesday, Wednesday.)  How can I sort
chronologically?  Thanks!