I've got this function that returns good results except for some records
return #Error.  This #Error is expected, and I'm trying to trap it and report
the record as "9:  Function Group Not Defined".  What am I doing wrong?
If [FuncGroup] = "Operations" Then

Currently I have a query that counts a text field called Policy
I need a query that sums this count field and evaluates it.
Say if the person has 3 violations they would be included in the query.
Any help is appreciated.

Hi Access-guru,
I have a macro that make & append data to a table. However, each time I
ran it, there will be messages popping up telling me that the old table
will be deleted and I will append # of data into my new table. I want

I have eight tables. Half of the tables show shortage debits (SEs) created
for the months of April - July. The other half of the tables show add backs
(ABSEs) to the shortages created for the months of April - July.  I was told
that I should be able to remove the AB from the ABSEs ...

I am doing a count of defects in a query, whenever I try to do a date
range as criteria, 2 defects that are the same are broken into 2
instead of grouped together.  The query works fine until I try to do a
between start date and end date.  How can I do a date range without 2

hi,
I have the following source behind a report:
SELECT Tbl_Archive.[Loan Acct #], Tbl_Archive.Date, Tbl_Archive.PopEnterDt,
Tbl_Archive.PrevStatus, Tbl_Archive.Status FROM Tbl_Archive WHERE

I have a table with expense details *EmployeeID, Amount, Company,Date*. A
table with Employee info *EmployeeID, First, Last, Address, Supervisor*. A
table with supervisor info *SupervisorName, BillingNumber, Dept*and a Dept
table which really just has 1 column list of depts.

I'm using the following parameter in a query to get records from a table
using a sub-form:
[forms]![ProductTable]![subdetail].[Form]![ID]
If the sub-form has more than one record, the query takes only the FIRST

Hello
I am using the formula NZ(cell),0)*1 as I need to poipulate any null values
with zero.
I then need to sum this so I choose Group by and then sum. This keeps

I have a query that reads in a date field from a table.
I've put 'Month: Format([Date Entered],"mmm-yy"); around the data, as I'm
calculating a monthly sum.
But when I go to sort the data by ascending date, it does it alphabetically.

I always second-guess myself when it comes to date math, and I'm hoping that
you guys can make sure I haven't missed anything.
I'm building an Access DB that houses reservation information for a hotel.
Each record in the reservation master table has a CHECK_IN date field and a

I am using the results of a query (sometimes a field in a table) as the
search creteria in another query. Sometimes I am successful and sometimes I
get the parameter query prompt. What am I inadvertently doing to get the
mixed results?

Dear Sirs
I have a table with 10 fields and a checkbox (yes/no).
I created an Append Query to add those fields to a destination table which
has more fields than the original table.

Access 97 with split FE/BE
I have a query based on 5 tables with one inner join and 3 outer joins in
FE.
Two tables have about 125,000 records each, one has about 17,000 records and

I have been trying a write a simple between dates expression for a query.
Nothing is working. Can anyone help? Between dates 01/01/2006 and 06/30/2006.
Many thanks