I have a query with SSN, FNAME, LNAME, and AMT. Each SSN has at least one
record; several have up to four different AMTs. I need to do a Make Table
query which will include one record for each SSN and the total AMT. I also
need their FNAME and LNAME. I can do a query that gives ...

I have a table that has two columns, one is for "downpay" amount the other is
for "totaldue" amount.  I'm trying to identify duplicate values to see who
has paid a downpayment amount equal to the total due amount.  I created the
duplicate query the problem is it isn't working ...

I need pass parameters to my crosstab query from different forms.
May I use me![txtParam] as parameter to suppert every forms using same
crosstab queries?
Your information is great appreciated,

I have a crosstab query for the report.
It fiills blank when zero counts.
Is it possible to make crosstab query to fill zero when zero counts?
Your information is great appreciated,

Hi- I want ot append a data from tbl1 to tbl2 with:
If tbl1.fld1=1 or 2 or 3 then append to tbl2.fld1=1
else
if tbl1.fld1=0 then append to tbl2.fld1=00

A have an access database that has linked tables to a SQL Server 2005
database.  A pass thru query was created for one of the report to use.  In
the properties of the query, the connection string has been entered.  The
problem is that prior to releasing to production, we link the ...

I'm not very good in SQL and encounter a problem. I hope someone can help.
In my following query, I try to use an ON Statement withe a condition, that's
to say :
ON CABLE.IDENTIFIANT=RCABLE_NDS.ID_CABLE AND RCABLE_NDS.CATEGORIE=1

I need to filter my query for weekend dates only. Is there an easy way of
doing this?
I was going to do a table on excel with all the dates for the time period
with column determining if they are week or weekend date. However, this is

I have a query which does a single keyword search across multiple columns.
anyonme have any code sample for being able to enter 2 or more keywords, and
query would return where Any or All of the terms were found.  
Thanks!

I'm not using SQL code, but the graphical representation in ACCESS.
I made a tmake table query to make a table of average inquiry counts.
(format 0.xxxxx)
and when I looked at the table, all the values are 0 and the

I have the following table where carrier field is empty
Ost        Ocity       Dstate        Region
Dcity                         Carrier
A            B              IL             MW            Chicago

Ok I am using this query to delete the books from the book_stock table
that havent sold for the past 3 months.
To do it accoridng to the date I am using the order dates from the
customerorders table, and to know which ISBN_Ref

How do I create a ranking feature in my query.  I want to rank the largest
dollar value as number 1, second as 2, 3rd largest as 3.....etc.
Any suggestions??

I want to make a form that someone can key in an ID number and the whole
record will display and then they can key in the blank field with data.  I s
this possible? Thanks

Howdy Folks,
I've done some searching, but I cannot figure out how to concatenate
multiple records into one field. I have a query that is pulling out some
chemistry data for me. I'd like to use it as the source for concatenation.