I'm constructing a line tendence graphic; I'm refering to records from a
CrossTab Query (CTQ) with Months of a year in Columns and Cost ($) of the
desire months in Files; but, the column of the month where a didn't have
records, doesn't shows amount of cost because doesn't exist; ...

New user please help....
In the crosstab query I have been able to query each dept's expenses by
month - last COLUMN being an extended total adding each month together by
dept and giving an annual ttl thus far for each dept.  I need a horizontal

I have a table that is a list of new loans opened since 1/1/2005. The fields
include the loan officer number, the account number, and the date opened. I
also have a query based on this table that sums the new loans opened since
1/1/2005 for each loan officer. In this query, the ...

I have a make table query and want to have it create an index on one of the
fields it is creating at the same time. Here is my query, does anyone know
how to do this?
--------------------------------

Hi, hope you can help - this is a bit long winded, so hope you understand:
I have a job monitoring database, and have 3 tables tblJOBS with StockNo,
Description, Qty, Job No (this is actually linked from another database),
tblJOBSTATUS with Job No, Current Status and JobColour and ...

I have two tables with a memo field.
I want to find all records where this memo filed is the same in the two
tables - but I can't join two memo fields in the query.
Is there a trick to do that?

I want to be able to have the user input a part of a word and find all
matches. For example:
[Enter PART of a Company Name]
if they enter: amer

Is it possible to sort by part of a string in a given field?  Here's my
example:
In the [RoomNumber] field, room number is specified with a string such as
19A-01, 19A-02, 19A-03, 20A-01, 20A-02, etc.

I have a table which diplays field placements for education candidates.  One
student may have 1 or more placements in the same quarter in the same or
different school districts.  If the student has 2 placements then I have
identical fields for each placement named placement 1 and ...

I have two different tables showing projected sales.  The first table is week
1 and the second table is week 2.  The field "Project Month" represents the
month in which the order is planned to complete.  As with any sales,
sometimes the project can move out to a different month.  ...

I have a very simple table with an autonumber field (total of 10 fields)
How do I write a query which returns only the record with the highest
autonumber in the entire table?

I have an app to access Oracle database from Access mdb file.
It looks that Oracle has it date format.
I have folowing SQL code:
"SELECT * FROM MyTable

I have no idea why this isn't working but I have a query that runs 4
different searches (5 total) based on data inputed through a Form called
[Start Up].
Here is what I have in my query (qrySearch):

I am creating a query that is looking for a all numbers in my table that are
betwween 11100 and 69979.  my result is bringing me numbers that are less
than 11100 (like 12) and numbers that are beyond 69979 (like 299825) .  what
am i doing wrong in my criteria?

I would like to create a query that will show me the amount of records per
week for the whole year.  The week begins on a Thurday and ends on a
Wednesday. I have a function() for the week call LastThurs() and is as
follows: