I have the following fields
order-id  value  items    date
1            100    item1   10/2/07
2            200    item2   15/2/07

I signed up with hotmail but cannot access my mail inbox and cant get on to
messenger live even after dwn loading it. whats going on?

steps in problem analysis

I have a query that I have a set of telephone numbers. Within the query there
is a tel1, tel2 & tel3 result. Sometimes the tel1 has the same value as tel2.
What I want to do in this situation is remove the duplicate text in the tel2
column but not delete the record

I have a very "simple" task. I have one table with [Part Number], [Qty],
[Date]. This is a production forecast for the next 12 Months. I would like to
crosstab this information by Row=[Part Number], Column=[Date by Month], Data
Field =[Sum of Qty]. The table will be updated at ...

All,
I need a "no-kidding" online MS Access programming class. Please help me. I
want to start from the beginner to the decent level of programming.
Thank you in advance,

I have a grand idea for a form but no idea how to design it!
I have form that has perhaps 8 - 10 fields that require filling in. The
nature of the data is that, for any given day of data entry, perhaps 6 of
those fields would be the same (ie the user would pick the same choice) ...

How do I change a field from "Last Name, First Name" to "Last Name" only?

Hi, I am using a Union query to join data from two different tables.
The columns that are joined include Memo data types.  The recordset
after the union query truncates the Memo fields by quite a bit.  I am
guessing that the fields' Memo data type have been changed to Text

I am trying to display everything on a query through a report, but when i
include some fields, then there is no data showing. here is the query that i
have, can anyone visualize what's wrong with it.
SELECT LinkedSalesOrder.OrderNo, LinkedSalesOrder.ID,

I have a SELECT query I'm having problems with (returns the error
message "you tried to execute a query that does not include the
specified expression X as part of an aggregate function").
Here's the SQL (yes, I realize this is a bad database design, but I

I am getting an invalid syntax error when I apply the * wildcard character to
the follow criteria in a query.
Like [Forms]![Search Specific Model]![modelNumberTextBox]
Can someone help me with what I am doing wrong?

I have two queries that work exactly the way I want them to.  The difference
between the two is that one query looks for a value of 1 in FloatTable.Val,
using tAlarms_OFF_IS_OK in the criteria, while the other query looks for a
value of 0 in FloatTable.Val, using tAlarms_ON_IS_OK ...

I have a large table listing agent name and premium bound on each new
customer.  I am trying to find the top selling agent, which is hard to find,
but I only want the query to return the high record, is this possible.

I've been fiddling with this for a couple days now but can't get it:
SELECT tblProfiles.txtProfileID, Concatenate("SELECT ProfilesAssociations
FROM tblPKProfilesAssociations
WHERE txtProfileID =""" & [txtProfileID] & """ ORDER BY