I've inherited a survey 40 questions, most multiple choice letter answers and
an additional 10 fill in/comment questions.
I can't change.  The data includes several past years which are being
updated and will contain new year data.

I have a query that I need to have assign an alias to the returned field
name.
SELECT Company.TypeofCompany AS Categories FROM Company;
The TypeOfCompany field refers to a lookup field in the Company table. The

Not quite sure where i should post this, but since i didn't find any "tables
discussion group" i ended up at queries. As i am already confused enough i
will use the original names for the stuff in my base and hope you can keep
track of it instead. I got 3 tables: Pet, Species and ...

Hi, I am trying to do a query with the following fields from the table
"tClinical"
patientID     visitDate                rank
123                 5/1/2003             2

Hello, I Imported a file from Excel to Access.  I am doing some comparisons
on some of the fields to ensure I have no duplicate information.  One of the
fields I am working with contains empty fields , so my query is basicly
"Select prsa_num from tblImport where prsa_num is Not ...

SELECT
(SELECT COUNT(*)
   FROM TOP100-RL-ReportStep2 Q1
   WHERE Q1.SumOfSumOfship_qty < Q.SumOfSumOfship_qty

How can I assign the next correct DO03 channel number and still have the
DO02 channels numbered correctly?
I have a query based on a table: tblSignals.
tblSignals has the folowing fields: SignalName, chassis, slot, chan,

I have inherited an Access database that was, until recently,
functioning normally. I'm still fairly new to Access, so forgive me if
my questions seem naive.
The primary user of the database is now having the database fail on a

I have two tables with a relationship as such:
tblAuto
ItemID(PK), ModelID, VIN
2411, 311, LLLLLLLL

I have a query with an expression in it but I'm getting an error message
"Can't group on Memo". One of the tables that I'm running the query off of
has "memo" as a data type. Is there any other way to make this query work
other then changing the data type to text?

I do not know anything about SQL, but I think I need SQL for the type of
query I'm trying to run if this is even possible.  Right now I have an input
form where a user selects 5 parameters from drop downs and then can select up
to 9 check boxes.  Once they have made their ...

I have the followng:
SELECT Tbl_archive.[Loan Acct #], Tbl_archive.PopEnterDt,
Tbl_archive.status, DLookUp("status","tbl_archive","[status] Is Not Null AND
[loan acct #] = [loan acct #]") AS Expr1

Is it possible to update a table with something like this:
UPDATE table1
(firstname,lastname)
SELECT 'newfirstname' as f, 'newlastname' as l

I'm using the next query to filled up a Grid on VisualBasic. I do need to
round "CurrMonto" to 2 decimals actually is showing 4.
SELECT IdGastos as IdNum, strRegistro as Registro, strGasto as [Detalle del
Gasto], CurrMonto as Monto, Cstr(Cstr(month(DateGasto)) + '/' +

Using Access 2003, I use LAST in a query to return the most recent Record
number (and use that in another query to produce the most recent record, as
the Access Help illustrates for finding the last record entered.)  However,
incorrect results happened when the number of records ...