I have two queries that give me the information that i need.  I want to join
these queries together to have the results show in one query, not two.  I
need this because i have to use the results for invoicing purposes.  'Offer',
a fellow newgroup user, kindly provided this sql ...

I have a form that has a query named "qry_MemberFirmsView" but this query is
not updating the table "tbl_MemberFirmsView".  The value is in the query but
not in the table.  The value came off the form into the query.
How do I get the query to update the table?

I have a nested query.  THe first one shows records for date 1 (say July
29).  I have a second query that shows records for date 2 (say Aug 31).
These query are then used in a third query, linked by a commom key. (Serial
Number)

I'm trying to write a query in Microsoft Access database that will give me a
random statistical sample from the data in the table.  For example I have
roughly 700,000 records of data in a table that I want to capture a random
stat sample of 400 records.

Short overview of the set up:
qry1 retrives data--> acct, sale1, date1(mmyy);
qry2_crosstab acct as rowsourse, date as column source, sale1 as sum value
Now I am trying to create next qry that will have month1, month2, month3 as

I created a data base table with names and addresses to mail to - I would
like to sort out only 4 states out of the 30 I have - can someone help
me?Thanks in advance!

I have a table containing numbers and I have configured it in standard
format, i.e. 12345.68 shown as 12,345.68.  However, when I transmit the data
into a new table by make-table query, the format is gone.  I did try to
configure the format at the properties of the field in the ...

How do I code a user form to maximize on open ?  Some of my users have
resolution on their monitor set so they can't see all objects unless form is
open full size

I had write a function in module to get multi value and used it in Query
unsuccessful. How am I modify to get "Fax" value using function in SQL. I
prefer to use such function to get multi values in stead of modified it to
return only "ONE" value.

i have a query that will return a large number of results (0000's) - but all
i really need the total of entries under different criteria.
Is there a way i can get the query to product just one result (the count )
rather than every record?  the catergory i wish to count a result of ...

I am attempting to sum various sums that are conditional. Basically, sum A + B, where A is:
SUM(IIF([PCPCAJCD1]="HC ",PCPYAJAM1,0)) AS YTD_PENHW1
and B is:
SUM(IIF([PCPCAJCD2]="HC ",PCPYAJAM1,0)) AS YTD_PENHW2

I would like to know, first, if it is at all possible and second, if so, how
to:
1. Join SQL Server 2000 table with an Access 2003 mdb (local) table
2. Append to a local (mdb) table with data from a SQL Server table, etc.

Using Access 2003, I have a Union Select query to combine information from
two separate tables.  In one of the tables there are two records that in one
field have the same value that happens to be the number 10,000.  The Union
Select query ignores one of these records.  However, ...

My bad.  I'm trying to clean up my db, deleting old queries.  I'm wondering
if there is a way to find out if a given query is being used by any other db
objects (forms, reports) without 1) poking around 2) deleting and being sorry.
Thanks!

How do I add comments to a query?