Hi there.  I have a table with relatively simple data.  If I build a query
where the criteria uses the Like "*" & [Expr1] & "*" expression, it works
fine and returns all the records.  What I'd really like to do is for the
query to provide a count of the matches rather that the ...

I'm trying to write a query and I'm not sure if it's even possible.
I have two tables - one with sales data for the whole company and the other
with monthly exchange rates for Canadian $ to US $. The problem with the
sales table is that the Canada sales are mixed in with the US ...

I am not sure if I am in the right Discussion Group, so here it is...
I have five different queries called ‘Cooling, Electric, Gas, Heat Pump and
Oil’
I would like to create a one command button on a form called ‘Contract’,

I cant figure out how to group my records by quarters or months.Is there a
special query to otain these results? My current SQL is pretty basic using
two tables as the following:
SELECT VendorInv.EnterDate, VendorInv.InvDesc, VendorInv.InvCode,

I am getting the following suntax error: "Syntax error in string in
query expression '[MonthNum]=6'""(second quote is not in the error
screen).  Here is my DSum expression:  Test:
DSum("Units","tblMonthlyUnits","[MonthNum]=" &

I am trying to average the total records by date range.  I am getting an
error message with my AVG expression.  Here is a snap shot of the SQL I have
so far.
SELECT [RCC Customer List].[Account #], Count([Incoming Return Item

I have a table of just months and years for example:
2008-01
2008-02
2008-03

I am trying to create a query that will show me all of the records in a table
where two fields in the record do not match, basically the opposite of a find
duplicates query, however the find unmatched query will not work for me.  I
have a table listing a client ID, an activity ...

I have a table [x confirmed], and 2 of the fields are 'practice' and 'month
name'. This table contains typically between 10 and 50 records for each
combination of 'practice' and 'month name' values - so for e.g. there may be
22 records where 'practice' = "The Health Centre" and ...

I am new to SQL in queries.  I can ussually get what I want with forms and
the query wizard.  This I cannot figure out and it seems like a SQL statement
might work.  I import data from a spreadsheet automatically (a click of a cmd
button).  I have most of the fields removed or ...

I have a Sales Branch Audit database in development.  I have all sales branch
information contained in a separate table (i.e. address, city, state, etc.).
The Audit Form (which populates Tbl_Audit) uses a combo box allowing the user
to select the branch being audited.  That value is ...

Why are columns are in a different sequence each time I run certain queries
and how can I stop it?

Hello everyone  I am kind of new on using Access so here is m thing I need
too create a tracking number that start like this "CUPR0800001" ok I need to
generate this tracking# for the table but I want that everytime I open the
form automatically will generate the next number for ...

I have table Customer with the field CP
I have the table Cpostal with the field CP_NUM
The relation between this two tables is Customer.CP 1->N Cpostal.CP_NUM
This means that the for one CP code in the table Customer i have N CP_NUM in

I created a query that works well using DSum , grouping and percentages yet i
can not figure out how to target a specific period by date since it breaks up
the grouping.My sql is :
SELECT VendorInv.InvDesc, Sum(VendorInv.InvAmt) AS Revenue,