I am working with MS Access.  My tables are:
table1:
var1      var2    cnt
null        1        1

I have an Access 2003 DB. It keeps track of product orders. I am
attempting to sum the order total for EACH customer. I can get it to
sum the order and add shipping but it lists each order number and then
the total. The problem is that customers show up multiple times if

OK,
This is such a simple problem that the answer is probably right in
front of me, but I just can't see it...
I have downloaded Duane's Concantenate demo. I have imported the

I've created a query that has a from/to criteria as shown below:

The possible numeric range is 1-99, so entering 7 and 7 gives you just
Pre-School 7's details, or entering 1 and 99 gives you every Pre-School's

i want to make a query in order to calculate volumes
in some causes when i make summation i have both negative and positive values
i want to get the negative values as  equal to zero in the query

Hi -
I need to run a query for a mail merge and need to have a "addressee" field.
My table has two name fields, "first" name and "second" name.
If there is a "second" name listed, I want to use that name,

I use the following SQL to update the QtyOnOrder in table SpareParts, but it
cann't.
the QtyOnOrder is single type.
     n=8

I have 45 databases that have corresponding fields which all contain the
same prefix. That is, 2 fields in 30 or so databases and one field in the
rest, and the values in those fields all start with a four digit number. I
want to change the four digit number on a regualr basis ...

We have a tree census done every so often, everytime a census is done,
a tree must be given a status code - there are cases that some trees
haven't been recorded or possibly missed during data entry.
I need a query such that it will run through block and if it locates a

I create queries for third party vendors that need access to our proprietary
school data.  Several of the vendors have asked for the data to be extracted
and exported to them on a regular basis.  While I'm not a newbie in Access,
I'm in the swamp when it comes to SQL code and ...

I have a fairly long SQL string that I'd like to wrap since I can't fit in a
single line. I'm not sure how to do it, any help would be greatly appreciated.
SELECT SUBSTRING(TLDSEU_CUR.OUB_SRT_DT,5,2) + '/' +
SUBSTRING(TLDSEU_CUR.OUB_SRT_DT,7,2) + '/' +

How do I make each column UCase in a query

I have a crosstab query that return the number of members by membership type
in each region (see below):
TRANSFORM Count(tblCustomerData.[Owner Number]) AS [CountOfOwner Number]
SELECT tblCustomerData.[Current Plan Name], Count(tblCustomerData.[Owner

I am using Access 2007 and trying to get a query to work well.  It picks up a
date from a form but does not do it quickly.  If on the other hand I put the
date (#10/4/2007#) in the criteria field instead of the  
=[Forms].[Form1].[Text13], the query works fantastically.  What is ...

I have a query that derives its criteria from a form.  On the form I have 2
fields:  Beginning Date and Ending Date.  
Here's what I want to accomplish:  If the Start date is null, then have it
use <=End Date; otherwise if the Start date and End date are filled in, I