I need to create a query to pull only people who have not had any activity
prior to Jan 1 of the prior year.  The table with the list of names does not
keep track of when a name is added but the activity table does keep track of
the dates of any activity.

I have tblSheet1 that has fresh data that I would like to use to append to
tblEmployee.  
tblEmployee has L_NAME, F_NAME, RoomID, Room, and tblEmployee.
tblSheet1 has the same except it doesn't have RoomID.  It only has a Room

I have a database with current employees. I need to find out out of all those
employees, who has been with the company >= 10 years. How do I write the
query for years for the hire_date field in the query designer?
Thanks!

I am pretty new to Access and do not know a whole lot about code.  I have a
report based on a query though, and I need to change it.  
I need to exclude from this report records in which the data in a certain
field is unique to that record.  For example, if I sell widgets to ...

In my conference registration database, I need to identify those people who
have a balance due.  The total amount due, total paid and balance due are all
calculated fields.  I need to produce a report showing only those people who
still owe money.  Using the criterion >0 in the ...

Hi: I have an Access query below.  What does the nz mean in the first line?
SELECT [Sub1_EE Deductions].SSN, ([Sub1_EE
Deductions].[Deductions]-nz([Sub2_EE NonPayroll Items].[NonPayroll],0)) AS
Deductions

I am using an append query to add records saved on a laptop to a table that
is on a network drive.  The laptop user has limited access to a network
connection.  I need to find a method that will allow me to append the new
data from the laptop to the table on the network, and also ...

I have a query that in order to sum up the Quantity based on Ship_Date I
added a field Ship Date:Format([Ship_Date],"mm-01-yy") this way when I create
my crosstab query off this one all data is rolled up and the column headings
are mm-01-yy (rolling 12 months).

I am converting a Crystal Report which I believe looks at SQL server data
(for which I am only secured to read) to a similar MsAccess routine.  There
is a root table linked to numerous other tables with outer joins.  We want
to find all entries in the root table that have no ...

I have a query that is looking at the assigned date and if it is not null it
goes to the WO# field and adds the next number to it using the
Nz(DMax("[GldWoNum]","[tblWOFile]"),0)+1 command.   I am doing all of this
in an update query.   The problem is it assigns all of the items ...

I have a query that gets the following information from my tables
ProductName, Voltage, Current, Peak, TargetDifference
(Peak and target are the same unit)
I have created an additional query to retrieve the Peak that is closest to

I keep getting this message when I try to put my pc on standby, "device
driver 3'com etherlink xl 10/100 pci for complete pc management NIC
(3c905c-tx)' needs updating, but I can't get it in windows updates.  Any step
by step ideas for a novice?

I have a form which autoexecutes every time a database is opened. that form
has a button with which runs a macro onclick. In that macro there are a
series of open query actions. One of those open query action is supposed to
run a make table query. the data from this table is ...

Is it possible to create a criteria based on a work week number for a field
that is formatted as a standard date (mm/dd/yyyy).  I would just like to
enter a work week number and not a start date and end date.  Can I do this?  
If so how would I write the criteria?

I am doing some calculations in a field that have some zeros and I get
#error since I can not divide by zero (I know this too). Is there a way that
I can convert #Error to a zero?
Eric