I've created a make-table query that produces a table named "tblStocks". The
SQL is as follows:
SELECT qryUnionStocks.CompanyName, qryUnionStocks.Profitability,
qryUnionStocks.BusinessRisk, qryUnionStocks.Industry,

I want to create a schedule that automatically updates, dependant upon the
date the user is viewing the report.
How do I create a query that will select the most up-to-date record, only
one record per person? The table will probably have multiple records per

I'm trying to return columns from a table where there is no match in another table on the
same column value, and the value in the first table does not have a space in it (multiple
words).
SELECT [Managers].[MANAGER]

Thanks for the earlier help but I still can't seem to make this work. I'm
using Office 2003.
I have 4 queries that hold credit card data. Each one finds the most recent
date of the payment and therefore the current balance on that credit card.

Hello and thanks for the help. I am using Access 2003. I posted this same
question last week but I could not understand the answers. So please baby me
along if you put any code in the answer. I do NOT do code and have no idea
where or how to type the information in the answers I ...

This query problem is a bit too much for me.  Maybe someone else could look
at it
Marriages
---------

HI! Im doing a query and getting duplicate.  I just want the max of Result
and the date for that result.
I tried using max in total for Result and it still show all the output, Can
anyone help me?

My scenario is like follow:
id        number    teamid
1            0            1
2            0            1

I was trying to add another field to a query and then re-save the query but I
get a 'circular' error.  I'm not sure how to fix this or get around it
without saving the query as another name and then having to go and change all
related reports, forms etc.

I have a crosstab query that selects data based on the contents of 5
fields.  They aren't complex - simply state code (2 digits), territory
(0 or 1) etc.
When I run the crosstab query, I get different results than when I use

My scenario is that i have 2 system with name and adress (100.000 names),
that have to be merged into 1 system without any duplicates.
The problem is that the spelling is not 100% between the system.
One way to find duplicate is to group name,adress and count > 1.

This is a continuation of the discussion of a 7/18.  The problem is that
Access 2003 at times introduces spurious aliases for field names in queries.  
This problem came up again when I rebuilt an .mdb, starting with a blank .mdb
and then imported queries, forms, etc, from the ...

Hello again. I can't seem to get this union query thing going right. I just
posted  a question about 7 items down the list with the subject "union query
still a problem". I have tried everything people have suggested to fix the
union problem but what keeps happening is that when ...

Hello, all.  I have two columns in a table; one name StartDate, the other
EndDate.  Each table refers to a user and details, obviously, their start
date and end date.  Those who have not ended have a null value.  To the
question...