I have a table that looks like:
A    B    C    D
2    5     3    B
1    7    11   A

I have a query with the follwoing sql code that works.  Then the second code
is basicly the same however it does not work.
The first code will let me enter data the second one just beeps at me when I
try to enter data.

I'm trying to take a query that pulls records out of a character table based
off of a form that contains two player names.  This in turn pulls all their
known and specified relevant stats, and then adds up their numerical values.
And then gives me the below query output:

I've got 2 tables containing Time Stamped entries on employees.
One table has a mass of entries.........several entries an hour...all in
order by TIME.
The Second table also has Time Stamped entries for employees....but only a

I've got a query where I want to find the maximum value from among 4
dimensions for each record in my tables.
If in tblSettings, I have fields: Length1, Length2, Length3, Length4,
how can I easily calculate the maximum length for each record (instead

I need to export data from Access 2002 into Excell 2002 - not normally a
problem, but the boss wants a separate tab in excel for each location.  Can
Access be instructed to break a query results table or report at each change
of location, then save that "page" to a separate tab ...

I've made two posts to the message board today, neither of which have
posted, so this is just a test to see if I'm doing something wrong.

Is there a way in Access to create a query that contains the table
records within the query itself?  I want to avoid creating a dummy
table and just use values within the query definition.  I was thinking
about using syntax similar to the insert into statement I would use to

I am working a field that is supposed to return the value from a subsequent
record.
This is what I have so far:
SELECT x_logs.vehicle_nu, x_logs.time, x_logs.date, x_logs.status,

My table consists of customer loans and I want to pull the credit score tied
to the latest loan for each customer.  For ex., customer made 3 loans:  
2/1/2005, score = 630, 5/1/2006, score = 680, 3/31/2007, score = 650.  I
would like to return the score value of the latest loan ...

Hello, I would like to run a query and check if there has been any records
returned (any data meets the query criteria) and if there is any records open
a report to show these records, however if there is no records I just want to
return to the main form.  

I need fast help while I'm in the office, with Access. I work with an Access
dbase and with several XL reports monthly. I have imported successfully, an
XL file into an Access Table and all of the data appears in the Access table.
There are two queries that nust be run after the ...

Hi, All
I need to modify current query to return following result for the report.
Summary Report should look like:
Badge   Unit   IssueDate  OTNotices  Regular   Total

I want to creat a query or query part or field that takes information out of
a query and totals all of that information.  for example i have a query that
finds all the products sold in 2007, one of the fields is the units cost, i
want the query to total all of the items unit cost ...

I have two tables.  Both contain transactions for a fiscal year.  ( Jul-Jun )  The first table
contains multiple records, per location, per month.  The second table contains one record, per
location, per month.  ( The first has electric consumption & money, the second has demand ...