Howdy folks!
I've got a query expression that is giving me a #error when the field
[Process Key] does not contain "A".  It goes like this:  Age: Mid([Process
Key],InStr([Process Key],"A"),1).  When the string does not contain the

I have a table ORDERS that contains the follwoing:
ORDER    LINE    PO    ITEM    QTYSOLD    CUSTOMER
I would like to create a crosstab query that returns a single line Number
with the following information (provided that I use an Order number

Hi again,
I have a situation that may call for either a multiple nested IIF, or
a Switch(), or a DateDiff, something else I haven't even heard of.
Basically, I need to get the number of days during a given month that

I try to pull a data from access with contain a speacial character "/" in it
but what i get is it not return a single data, so how do i wanna retrieve it?
below is statement I use it but it return nothing.
SELECT LDDATA.COR, LDDATA.CON, LDDATA.PCODE, LDDATA.QTY, LDDATA.BOXNO,

I'm trying to figure out two related things:
1. If I have a query that is a join (one-to-many) of two tables which I use
to produce a report, but then I decide I want to use the query also as the
basis for a report where I just want to return one row for each record in the

I have a complex query coming from just one table of order
transactions (tblTransOrder).
It shows by club and then by Year/Cycle (Yr/Cy) order lines, order
values and the same detail on orders again but split using calculated

Just to preface this, I am a very very big beginner, so in case I don't make
sense, I apologize ahead of time.
I have a query set up that includes the following fields
Patient Number and Patient Name, joined by patient name from two seperate

I used the fomular below to sum the fields. I works fine. I need to add the
table name (Student) to this fomular.  Please show me how. thanks. Chi
Total Score: Nz([Section 1 - Pain Intensity],0)+Nz([Section 2 - Personal
Care],0)+Nz([Section 3 - Lifting],0)+Nz([Section 4 - Walking] ...

I have a question concerning the display of a calculated field based on the
DateDiff function.
Assume there exist “Start Time” and “End Time” fields that contain valid
date & time information, and the date and time difference between these two

The following is the scenario
stock _ in table
Id      item_no   pcs
1            1            10

This query with implicit JOIN works fine.
select * FROM A, B, C
WHERE C.ID = A.CID
AND B.ID = A.BID

I have been trying to manipulate data from a fairly complex database. I am
creating a report that is counting a specified field once it has gone through
a query and a couple of filters. The SQL statement became too long for the
complete calculation. I have now decided the break up ...

I have a query which shows the info i require. It shows Examiners & the
programme types they are associated to.
Each examiner must have 1 programme type but can have a max 2 programme types.
The query shows the data as expected. If the examiner has 1 programme type

This code returns the Month.
I need another column to return the year but there is not a YEARNAME
function...
IIf([TR_CLOSEDATE] Is Null,Null,MonthName(Month([TR_CLOSEDATE]),True))

I want to take the following module, and have the info added to a
table when the user opens the database, and removes the user from the
table when it's closed. I have to maintain this database and need to
be able to see who's in it at the time. It's practically used 23 hours