I'm using a Crosstab query (from multiple tables) that columns represent
month value of the year and files represent cost in$, each month;query with
"Between Initial and Final Date" criteria(in chort format). I need to use the
query to make a graph with line tendence showing the ...

Thanks for the help. I'm using Office 2003. I have a table with a field of
dates. In my query I need to ask for the most recent date from the list. How
can I do that?

I'm running a query and my field criteria comes from input fields on a form.
If the input field on the form is blank, I want to retrieve all the records
regardless of the value of the specified form. If there is a value in the
field, I want to only retrieve those records that ...

i have a query which include some double quotation marks as below, (T
is table's variable name)
SELECT Switch(IsNull(Amount),"NULL",Amount<=10000,"0 t
10000",Amount<=20000,"10001 to 20000",Amount>20000,"20001 and up") A

I have a combo box on a form and when an item is selected, I want a query to
be returned with the results filtered to the selected item.
For example, when "Project2001" is selected, the returned query should only
display the data relating to Project2001.

Access97 question:   Person Table has a field CompanyID which is indexed and
Memo field which is Text..  Company Table has field CompanyID which is
indexed and CompanyName which is indexed.
Is there a way with an Update Query to take the Person Table Memo Field

Please help. I've been ramming my head on my keyboard from trying to
figure this problem out.
In a query, I have two tables. One of the tables (table 1) has a
uniqueidentifier and other fields regarding the characteristics of that

I have a query set up that uses the contents of two text boxes on a form for
selection criteria.  I am trying to use that query in another crosstab query
(using a transform statement) and I get an error "The Microsoft Jet database
engine does not recognize ...

using Access 2002 SP3 at work.  I am finding that queries are not returning
records unless the criteria I enter are cut-and-paste from underlyng table.  
For example, I need records from an "Activity" table, of the Type "Customer
Approval".  If I simply type "Customer Approval", I ...

Does anyone know of some limit? I have a table with three columns
[datestamp], [timestamp], [tons_per_hour] There is a record added at 15
minute intervals to the table. I rotated the table on the [timestamp] column
which means I'll always have 96 columns (one for each of the 15 ...

This query sums a calculated daily value for mgd for January and sorts to
show a maximum daily value.  Fields are date, time, gpm, mgd.
There are hundreds of values for each day of the month.
PARAMETERS [What month?] Byte;

I am trying to generate sql scripts from Access database that can be used to
create databases in different database systems. I have tried a few third
party tools such as Interbase Data Pumper and SQL To Interbase Wizard;
however, they don't do the job well.

I have four PC's at the high school offices. One of them will not display the
queries Window when I go to select a query I am using for a form letter.
This works on three machines, but not the fourth.
I tried the following solution, but it did not work.

The first query return a type conversion error when executed within
MS-Access 2002 sp3. The proble is that parameter :MOD_TYPE is recognized
as a Text field even if the corresponding field MOD_TYPE is of type Text
and 20 characters long.

I am not a SQL expert by any stretch of the imagination, so any help is
appreciated.  I have a simple problem, I think.  I have a dataset that
consists of fields "Item", "Suffix", and "Length".  I need to get a
resultant dataset that includes the HIGHEST Suffix for each Item along