[CityName] contains the names of the cities.  [ParadeDates] contain the dates
of all the events for that city.
I need the query to return the MIN of the [ParadeDates] and also the MAX of
the [ParadeDates] for each city listed.  The MIN and MAX would be in two

Is there any way to take a report and make the results into a table?  Sorry
if this seems a stupid question, but I'm a novice in over his head on a
project I volunteered for.

I have a list box on a form that has two columns.  I need to choose a line in
the box but only query using the value in one of the columns.
How can I do that.  Can I write a criteria statement in the query design
view to only use that one column.

I would like to automate the append/update of a related items table
[tblRelatedItems] for our
B2B web. I`m not sure how to collect and identify the "related" items
to append/update.

Hi - need some assistance here ..
I have a table that has a date column, number of fronds, palm number,
block number
The date is for when the recording date of number of fronds for each

I am getting my data from an ODBC connection, using Access 2003. The
application refresh all the data when the user clicks on a button. It
refresh the data by deleting the old table and substitude with a new
table, I have a make table query to do this. All this is working fine,

My general goal: I have tblStudent with a an initial term (field = cohortno).
I have tblGatewayActivity which contains multiple term entries per student
in tblStudent.  I want to calculate academic persistence per cohort, for each
term.  Thus cohortno 1 starts with 20 students, ...

Not sure if this is were I need to post my question or not.
I have an Sales Inquiry Screen that has a combo box on it to select the
customers contact. After all inquiries have been entered in they will print a
shippable report. If on the Inquiry screen the user does not select the

I have an Access database with the details of 100 people on it, including
their ages.
I want to write an query to calculate how many people are in their teens,
20s, 30s etc, but can't work out how to do it.

hey
I have 42 Tables and i am looking to combine them into one MASTER table
there are 4 common field i am looking for.
There is the long way of doing this running 42 queries. I have that set up

I want my users to be able to run a report by a date range parameter and be
able to use a drop down to choose a "Provider" name from that field.  How do
I write a query that will allow them to do those two things?

I'm not an expert on this but here is the thing : a simple query that reads
all records from one table, Sales. I have a field named comissions. It's a
simple product from Value multiplied to 6%.
My question is : How to list all records of my sales, and that field,

I've got an application with what amounts to the main query being based on
two main tables and several other smaller tables.  The two main tables are
tblPeople and tblEvents, with the app being built around tblevents.
Because there are three people associated with three events (I ...

I am building an application in VB.NET... It connects to 2 databases MS SQL
SERVER 2005 and MS ACCESS 2003 .. It works all fine with SQL but It only
reads the record from the ACCESS table which is linked with SAGE ACCOUNTING
SOFTWARE V 11... Now When i Update or add record to the ...

I am reading a book about Access project with SQL server.
When I create a project, it will ask you link to the server step by step,
which I link the server successfully.  But also the book introduces:"Creating
a Global Connection Object Using VBA code", which I also made it works.