I am using Access 2003.  I have a query that I am trying to get to show only
patients on the adult areas.  I only have 4 areas that are pediatric.  Here
is my sql, but I used the query grid to make my query.
SELECT tblPatients.PtID, tblAreaList.AreaName, tblPtLocation.PtLocStDtTm, ...

Where can i find example help web page explain crosstab query?
thank you

I have a database that has a text field called "visit"  it has been
filled with data ie.,    " 6/22/07 - not good, "   the field may also
be blank or it may contain random text after the date. In some cases
no date at all just text. I would like to create a new field called

dears,
here is the table and report requirement any one please help as im going to
face the exam on 10/02/08 13.00 hrs please .b'cse its my employment .
here is the table Employeename . text

I would like to create a query that would populate a table with a series of
numbers.  For example, let’s say I would like to populate the table with a
series of numbers from 1 to 10, how can I write query that would effectively
act as  FOR-loop.  Where the series can begin at any ...

I have a person table that has id, firstname, lastname, address, city, state,
zip. I have set all fields except id to have required = no and allow zero
length = yes. But when I try the following query it will not insert the
record because the firstname is not filled out. Any ...

Hey folks:  Stumped again!
I have a data table from my phone switch that looks like this
dn, name, type, keynum, fcode, param
2000, Sally Smith, m2006, 0, scn, 2000

I have a parent-child relationship where I want to be able to select all the children of the parent which meet multiple
criteria on one field. For example, for a parent name of "Big Creek" I want to be able to select all the child records
in which the map field contains "Dunsmore" ...

Ok, here's the scenario:
I'm trying to count calories consumed by an animal each day.
I have a table FoodTypes with the following fields:
FoodID (Autonumber)

Who can give me a hand?
I am using the function below; so far so good.
DAvg("[wng_OPP_SLPK1]";"TBL_Woningen";"[wng_CFT Code] = """ & [pdt_CFT code]
& """")

I know the answer is right in front of my eyes, but its one of those days and
I have wasted too much time on it already..
I have a column within a table called Networth. I want the user to be able
to enter a number in a textbox on a form and return only records

My sql statement is having problems with this portion:
HAVING (Sum([pre_tax_amount]+[pst])<>0) AND (Description NOT LIKE '*TAX*')
AND (Description NOT LIKE 'GST*')
essentially, i want to have all records returned grouped by x,y, and z and

I have a database that has 7 update querys that all update to the same table.
is there a way to string them together with one???

I have several crosstab queries were the end user will be selecting a report
by month.  I have declared the parameters of [Beginning Date] and [Ending
Date] in the query and it works great but upon opening the report, it asks
for the dates twice.  I have read the threads on ...

I am having trouble with a query which involves multiple parts. It is tied up
with asset management. In a nutshell there are three components CRC(Current
Replacement Cost), ACC_Dep (Accumulated depreciation),WDCC (Written down
current cost). Other commponents include difference ...