I have a query that assigns a rank to competitors in an athletic event.
SELECT tblEventResults.fkAthlete, tblEventResults.fkMeetEventID,
tblEventResults.STimeResult, (SELECT Count(*)   FROM tblEventResults AS T  
WHERE T.STimeResult <  tblEventResults.STimeResult AND T ...

In the join below, all fields from tblPMHlookUP are populated with data (it
is a lookup table after all). When I run the query I get the info I want from
tblPmhDX but I only get the fldDxDesription from tblPMHlooUP. fldICD9code and
fldTypeCode come up with no data. These fields ...

I have a combo box that has a query for it's Row Source.  Maybe there's a
bug, but I can't erase this query to replace with another query.  When I do,
the form will not close or when I reopen the database, the original query
shows up in the the Row Source.

good day to all
i am having a weird duplicates problem with a query.  i initally started in
SQL, but then went to the query designer to ease the tweaking process.  i
have two tables who share a one-to-many relationship.  in this query, i have

Hello, I need some help.  I have a query that returns records based on
a date range; that works fine.  The problem is that if the date is
empty it won't return that record.  I am using it to count buses that
have ads that willl expire within the date range specified but I also

I'm got an app with mulitple forms / cross-tab queries / regular queries...
etc.
It also links to mulitple tables (2-3) at a time.
All of these tables have a common value.......a Route Number.

I have a table containing data regarding patients' visits to medica
offices.  Here is a sample:
Patientnumber        patientname    dateofvisit
001            Joe        1/15/04

I am using a calculated field called "Balance" in a query which is the sum of
total credits less total debits for an account.i.e Balance: sum(([cramt]-
[dramt])) and is OK. Now I want to it based on Account Type. i.e
            If Acctyp = "D"  Balance: sum(([dramt]-[cramt]))

I have rebuilt a crosstab query to use the datecreated field (data type=date)
that vived me a table to visualise my creative productivity.  It's part of my
studio database system I am building (ongoing).
However I have struck a wee problem and unsure what to do.

I'd like to have a query that uses a selection criteria that combines a value
entered by the user and a wildcard.  In particular, I have records that have
values such as 13050, 13100, 13200, 15100, 15200, 16100, 16500, etc. in one
field.  I'd like a user to be able to enter just ...

I created the following expression in a query:
AorB: IIf([Group Name]="*A Auto Install*","Auto","Borrow")
I am trying to pull out the Group Names that have "A Auto Install" contained
within the name and return the name Auto.  If the name does not include "A

Query Index Questions:
Suppose that I have two tables Y and Z.  The following are the facts
concerning the tables:
Table Y has a primary key based upon fields A,B,C,D.  There are over 3

I'm fairly new to this, so I could really use a hand.
My query has just 4 columns; StudID, SchoolID, SchoolName, ContestScore.
I need to find the sum of the top 3 scores from each school, then rank these
in descending order.  (for schools with < 3 participants, I sum all of their

I'm not sure if this is a query question or a reports question.  I have a
database where the table has an input mask to include the area code for the
telephone numbers.  The report (based on a query) shows the telephone
numbers, but I'm wondering if there is a way that the report ...

How can I make the output of a calculated field display without decimals? The
calcualtion below works to calculate the calculated QT Time which is
cardiology related and I won't bore you with the details. I need the out put
to round up. I need to see 730 as opposed to 730.742003 ...