Can you do an update query using a SubQuery? I would like to update a table
using a query for the new values.
UPDATE “table1”
SET “Column1” = (SubQuery.Column1) and “Column2” = (SubQuery.Column2)

I have affiliates I pay residual payments to.  I have a query that pulls the
residual data from a table and a report that uses this query to print out the
reporting information.  I do not want the information to come up in the
reports for any affiliate who's residual is less than ...

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

Hi,
I have got an Access03 frontend with an Oracle9-DB as backend. Somehow I
cannot edit some (and no special!) records in my table Alle_Personen. Access
tells my sth about a write conflict and that another user had changed some

How can I save a filter as a query? How do i open the query dialog box?

I have a table with the following data:
IdStbd       IdIndctr       Index
   1               1              1.1
   1               2              1.2

I am using access 2007 and am having trouble filtering dates in my queries.  
I have a qry with multiple date fields.  However I am only narrowing the
criteria in the [discharge date] field by using >= [discharge date].
When I enter 10/01/2007 I get 40 entries from september.

How to identify second to last (in maximum) data
WIth data like this, with repeating Order Numbers (for example):
Area Code   Order Open Date
123             2/1/2005

Using Access 2000, I am trying to find a good way to sort a secondary
column in a table before an autonumber is assigned for each record.
We have a db into which we regularly import two data files -- a
transaction file and a details file, related via a trans_id.  

I am trying to select only certain data to appear in one of three queries I
have created.  The main table houses all the student information.  I want to
sort all the names into three different queries and am using the "Between
And" selection on last name (i.e Between "A" And "N") ...

Can you have a field within a query that is an autonumber?  Like when you set
up a table.

I've a query that has 3000 records I've the phone number to  use to join the
query to a table that has 50000 records  and the same phone number. In the
query the phone number will appear more then once and in the table the phone
number will appear more then once. In the table I want ...

I would like to do a select count statement and display the results in a
msgbox.
Is that possible?
ex

Let's say I need to make a query that results in fixed length fields.
How would I tell the query to add the necessary empty spaces (if the
value in the field is less then the fixed number of characters)?
I guess it's kind of an anti-Trim: TRIM([field])

Hi
It's any function of queries to check then delete the duplicate date in one
field?
-rgds