I need to append records from a table in a db with no security to a table in
a db with user level security.  All users access the secured db with a
shortcut - meaning I think I need to be referring to the workgroup in my
code.  

Is there a performance difference between these two query criteria
statements?
Not Like "aa" and Not Like "bb"
vs.

Below is the SQL of a query where I have set up a text box "txtFldMth" on a
form to pick up the field. The field Name is "Jan-07" and is in text format.
Even though the text box on the form reads "Jan-07" it still asks me to enter
the parameter Pegasus ...

I have built a form with (3) combox's that display different selections.  On
that form I have a command button. I would like to built a query based on the
selections from the combox and the results are placed in the subform.
Example.

I have the following query and i need to only have files that have aggregate
totals >=5000.  If someone could please assist that would be great.  Thank
you.
SELECT [03/12-19/01 by date].SSN, Sum(qrySarsAggregateTotal.Aggregate) AS

Iam creating a Parameter Query using BETWEEN [Begin_date] AND [End Date].
But the End Date is not inclusive in the query result.
What am I missing?
Please help.

I  am using access 2003. I have a query that pulls data based on group by and
first in the total row and the data is good. My problem is when I create a
table based on this data some of the field names become firstof..... Is there
a way to eliminate the 'firstof' part of the ...

I have a query that returns duplicates based on two variables.
Inmate#
Product
What I need is if the Inmate has 4 or more of the same item then it gives me

I'm trying to count the maximum number of consecutive years that an
individual has made a gift to our institution. I have a range of 35 years to
consider and all my information resides in one table. It doesn't matter when
the last giving year was as long as s/he give 'x' number ...

I created a form that links to a report that uses the statement below as a
record source.
Example:
Select value_name,value_yr,value3

I want to create a query that returns the dates of the next five Fridays.
Is this possible?
Simon

I am trying to append Fields from two tables :
        SKU, CustFinInvoice, CustFinQty From [Order Facts] - Pri Key SKU
        SalePrice from tblPrices - Pri Key SKU
        WIC as a computed Value ( [Order Facts].CustFinQty *

I want to add a field to a select query that will number a set of grouped
records from two related tables.
Table A has a list of locations with addresses etc, table B is related via a
lookup field and allows the selection of city names. I want my query to not

I'm having a bit of an infuriating problem which I'm hoping someone will be
able to help with....
I'm using Microsoft Query to dump data from an Oracle db into an Excel
spreadsheet, and need to pass a date from a cell so that the data returned is

I have receive help with SQL that gives totals between a certain period of
time. I would like to know how to get the total prior to the requested time
in the query and also have have quarter to date. I am including the SQL of
the requested time frame.