I'm using Access 2002 and need to distinguish admission dates from a series
of other service dates.  This could easily be done by grouping ClientId and
using Min([Service Date] if each client had only one admission; however, I
need the query to recognize when there is a break in ...

I am creating a query from several different tables containing housing data.
My final goal is to create one query that contains a single column with the
"housing ID number" along with all of the other housing information in each
row (address, owner, management...)  Due to poor ...

Is there a way to group queries together like in folders?  Or is there a way
to change the font color of the query titles.  WHEn you have so many queries
to look through it takes so much time finding just the right one. I know that
choosing the right title name helps but still if ...

What I need to do:
I have some rather expensive inventory items that I need to keep track of.
These are to be used in several projects (jobs).
I'm trying to design a simple database to help me keep track of where

First question, is there a way to specify what order the columns appear in a
cross tab query?
Second, is there a way to distribute a value in one column of a cross tab
query across new columns?  For example, if I have a total value of a

We've noticed on a couple of our queries that when we run the query we get
all the columns in the table. However, in design view we see that we have not
selected all columns. Anyone know why this happens???

I'm trying to build a query that returns only the five most expensive items.
The field name for price is selling price.
I have looked at the sample database Northwind that comes with Access. I see
they have a query for the ten most expensive products but cannot find where

Can anyone help?
I have a system where employees register property with us. They then report
back to us when they sell the property.
Registered properties are held in one table and sold properties are in

I have a date field in a query "appDate", and also I have created a form to
select the quarter and year.
A drop down box "cmbMonth" gives the options of "January, February, March"
and "April, May, June" etc for the quarters and another drop down box

I hope you can help me with the next problems I have:
Question 1: Merge two tables
I  have a table with shipped cartons in peak and average month
ShippedAverage

I looked, and maybe I'm just blind, but I couldn't seem to find an
access forum on Microsoft's own website.

I need to add column totals to the bottom of my crosstab. Here is the
code:
PARAMETERS [Month] Text ( 255 );
TRANSFORM Sum(MSF07.[Share Total]) AS [SumOfShare Total]

I am trying to build a report based on a query.  All the information is in
the one table.  There are two work programs, and what I need to do is create
fields which count all the jobs done in a financial year under each work
program,

I have created a crosstab query for a form which I am putting into a report
as a subform.  I have created a popup form which asks the user to enter the
Settle date which he wants the data in the report to contain.  I am having a
problem getting the crosstab query to accept the ...

May I know how to do a date different between a given date in a field and
today's date.
I want to add a field on aging and calculate the date difference in query.
For example : Aging = diff( transaction date, today date)