Good Morning!
I have the following expression built:
OHPerc: NZ([SumIHours],0)/NZ([WorkHours],0)
In the properties I have it formatted to show ##%

Table = ChildEnroll      field = Child_Date_Of _Birth
How do I create a query or report showing how many children will turn 6 year
old next 12 months
Thanks

I am trying to use an update query to change values in a table to negative.
Any suggestions.

In the below query, I'm trying to Concatenate 3 fields using Duane Hookom's
function. It works, but for some reason, it's cutting off data at the 255
character limit. First, I tried MAKE a table. Then I tried appending to a
table TCS with tts being a Memo field. Same difference. ...

I have inherited a database with just one table[table1].
I need to split this table down into other tables.
One of these is to split the clients off, however every record in
[table1]has the client, so when I perform a select query I am returning all

Right now I have a table which holds employee_id and Hours_Worked during any
given week. Week_Start 07/01/2007 Week_End 07/07/2007 represents wkdays 1 and
7 respectively. However, is there a way to populate a new table for reporting
purposes that gives me the actual day worked, ...

I have created a query that sums data by month in Categories.  I want to
create from this query or within this query a ytd total of the summed data
("Sentin000's") where the fiscal year begins in October.  I also want to
create a percentage of these categories compared to a ...

I have an Access 2003 database that is used for our mailing list and keeps
donor records.  How do I make a query that will tell me all of the donors
that have not given in the last five years?  I was able to do a query that
gave me everyone that had donated more than $100 in the ...

i simplify my table as follows, to which field2 needs to be inserted, based
on the sequence of duplicate field1. but i have no idea how to do it...
Thanks for reply!!
______________

Here's my query:
SELECT DISTINCT Tools.[Tool Number] as [Tools/Tool Number],  [Order
Entry].[Tool #] as [Order Entry/Tool #], [Order Entry].[Part Number1], [Order
Entry].[Part Number 2], [Order Entry].[Part Number 3], [Order Entry].[Part

I need help with a query that will look up the value of the previous record
of the overall revision but with the same quote number.  I would also like to
subtract the previous sell amount from the current amount.  Can anyone help
me?  Here is the sql of the query, your help is ...

I am trying to do an update query and getting the message "Operation must use
an updateable query"
I'm running the following SQL:
UPDATE Quarters2 set [Admits 1000] =  (([Admits]*12000)/(select Sum([Members])

I'd like to return results that show calculations based on the day of the week
for example
Date             Total
7/9/2007        3

I've read just about every message regarding using Wildcards with a parameter
query but am still having problems.  In my parameter query I input "Station
#2" but I get all the stations shown below (Station #7 is coming up because
"L42A" is part of Station #7's string).  

Hi all, does anyone know if it's possible to get Access to perform an
inter-quartile range (IQR) calculation in a query? i have a large amount of
data and would ideally like to use access to pull out certain stats. thanks
in advance for any help!