I have a union query that is quite simple:
SELECT DetailCust.OrderNumber,
Mid(DetailCust.ProductCode,3,2)+MID(DetailCust.ProductCode,7,2) AS Expr1,
DetailCust.Quantity, DetailCust.UnitPrice, DetailCust.ExtendedPrice

I could use some help.  I have a table with customer info and a table with
contracts.  They are linked by an ID field.   I would like to create a query
that only links the most recent contract (it is determined by a date field)
for the customer.  I know this sounds simple but I ...

I need some urgent help with quarter field
I have 3 columns in my database
OrderNo, OrderData, OrderAmount
say that the date right now is Jan 07

I have two tables. Table 1 has say HHID 1 to 1000 (1000 rows) and
different fields. Table 2 has only intermittent HHIDs say 456, 12,
23..and 100 such HHID (so it has 100 rows) and a field, say field1. I
want to merge table 2 to table 1 with HHID's being the common field.

I have a database where I am attempting to create a complex weekly
report for employee production. I am struggling with the date portion
of this project.
The table I have includes the following production information.

Is there any way to create a table name in a make table query that will
include the date?
I want to have a history of tables and would like to have the date as part of
the name ie DivAll20061226.

The Select query displays 1287 records.
When I created this query without the Fiscal Month table, I got 1287
records. When I added the INNER JOIN with the Fiscal Month table, I only get
28 records, although I used this query on another table and it worked well.

Ok, I have a picky boss who is asking me to make a query that will show all
spending by payee and also show project spending in same query. Is this even
possible? The estimated number is a number he want to plug in, not a
calculated number.

Can I add several colums to a access table in a single ALTER TABLE statement
?
I am using ODBC, but always get a syntax error.
Thanks.

In short, if tbl2 have some value in it, retrieve only the matching records
in tbl1 otherwise, if tbl2 is empty then retrieve all the records from tb1.
This is what I have done, but if I live the control empty from the form, no
records are retrieved at all, ignoring the "is null" ...

I've customers (client_id, customer_name) who have ordered (order_id) items
during the year (date_in) and than stopped ordering. I'd like to list the
customers who have not placed an order for the last 6 months. Can someone
help?

i have a table contain 15 fields, how can  write a sql to query those field
name?
Thx a lot
nelson

I know this s basic but I don't know what I am doing wrong
My table with fields: datum (=translation for date) and therapist
I want to count the records per therapist with year(datum)=2006
Thanks people

I don't understand Duane. What control could I use, a combo box and a list
box would be too much data for those particular controls. I'll be going off
of invoice dates and I'll be going back several years. That means I'll have
365 dates x those several years. That's why I'm ...

Hi there (Greetings)
I am constructing some forms on which data will be entered. I need to
save this data to either a database (access or oracle) or spreadsheet
(excel)