I'm trying to create a query that lists records in the AllNewParts tbl where
RefPart/RefPart NHL don't have a matching Part#/AS Part# in the
ExcelARefParts table.  The following fields need to match:
AllNewParts tbl    ExcelARefParts tbl

The following code produces a count Per Reviewer and Per Month.
I'm trying to split out each month in a seperate column, this is not
working, could you please help me out??
Trying to do something like this:

    Having a bit of a problem with a summary query.  When it's just the
carrier and area, I get returns with this code:
SELECT [CNameFirst] & " " & [CNameLast] AS Carrier,
Count(tbl_SubscribersData.SubID) AS Subscribers

Hi. I've got several records that have no data on some columns. I want insert
zeros on those records witch has no values, but on the records that have
values I don't want to touch on those.
I try to make a queries to insert but it asks me for a critaria, but the

I split a database and now have a front end and back end.  Everytime we run a
make table query, the table is created in the front end, how can we run the
query to create the table in the back end.  Or do we physically move the
table to the back end create a link to it?  Creating ...

I have a query where I am trying to pull the Project Number, The Resource
Role and the Actual Hours worked for the month.
I have seven roles that I track and I want each of them to appear in the
results whether there are hours applied or not.

I have received much help from this Group and I hope someone can
help me with this:
My form has two combo box’s [cboEmployeeId] [cboJobId]the purpose of the form
is

I want to give a "point" value to a selections made in a combo box points an  
(ie. time in related field is > 5 years, they get "5," for 3-5 years they get
"4")  Is there a way to do this?  I would like to total the values for each
answer.

Hi. I would like to know whether the following can be done using a subquery
(I 'm currently using 2 queries to get the desired result)
Consider the following table:
ID Date ProdID ModID Inv

I've come up a bit of a problem with a planner/reminder program I am
making. I am using a Month view calander as a date selection option,
and am using this to write reminders to files using the code below:
Private Sub cmdSaveEntry_Click()

Is there a flag/setting/function that will supress (or default) the value of
#error when calculating two values
example
Working out a percentage (thanks to help from here) you can pass two values

I have a question...I have 6 tables (Test Value, Calculated Value, PI
Value, Diff Value, Test Uncertainty, Diff Uncertainty).  Each of these
has the first paramater named "Time" as the Date/Time for the record
and then 500 other parameters of interest for the table.

I am using the query as(example)
Select * from Q1 where frequency=F1(WeekNo)
and using this function as
Function F1(WeekNo As Integer) As String

I have no option in my advanced e-mail section to turn on the suggested names
feature. Is there an update for this ?

I have a fairly data intense Contact database.  I am trying to run a simple
query that will filter contacts based upon a certain category.  This category
column is set up as a combo box on the main date table.  When I try to search
by a single criteria, the list will not populate ...