|
|
Age of a group for a fix day by
Telesphore[_2_]
How to calculate the age of the persons of a group for a precise day?
Example: what age do each one will have on July 1st 2008?
Thank you
|
May 11th, 2008 05:36 PM
by fredg
|
1 |
109 |
|
|
AGE RANGE SELECTION by
Jasmine
I need some help with figuring this problem.
I have a table called - RETENSION with the following Fields-
ID ( Autonumber)
ISSUE AGE (...
|
November 14th, 2007 07:52 PM
by Dale Fye
|
3 |
77 |
|
|
age rounding up or down by
Abe
I'm using this formula from the office help to calculate a birthdate:
=DateDiff("yyyy", , Now())+ Int( Format(now(), "mmdd") Format(
, "mmdd") )
My fields...
|
September 16th, 2009 07:36 PM
by Abe
|
3 |
146 |
|
|
age-categories by
Jean-Paul De Winter
Hi,
I have a table of about 4000 patients
all have a "date of birth"-field
It could be nice to know how many patients I have form
0 to 10 year
10 to 20
20 to...
|
|
1 |
82 |
|
|
Aged Customer balances by
q
I am trying to write a query that presents customer aged balances into 4
predefined columns: Current, 30, 60, 90
There must be a common approach to this...
|
|
1 |
69 |
|
|
Ageing by Date to 30, 60,90 etc by
WendyUK
I am trying to age transactions into 30 days, 60 days etc and have put
together the following script but is giving a syntax error on "AS" on the 2nd
SUM...
|
April 20th, 2007 04:32 PM
by WendyUK
|
9 |
137 |
|
|
Agents and sub Agents in a query by
Inma
Hi,
I've Orders and Agents tables joint in a query. The Agents table has
AGENT_ID and MNGR_ID. The query pulls the monthly orders per Agent. Some
Agents have...
|
|
1 |
132 |
|
|
Ages of participants by
Desmond
I have a table with a list of people's birthdates, and a
resulting query calculating ages. What I would like to
do is create a report that will tell me how...
|
|
1 |
180 |
|
|
Ages Query by
dukes1234
I'm trying to find the number of infant participants aged 0 to 11 months
and 12 to 23 months within my database in 2004. For 0 to 11 I just put in
"Between...
|
February 15th, 2005 04:11 PM
by Rick B
|
1 |
86 |
|
|
aggiornamento form ricalcolata by
madmax71
qualcuno saprebbe gentilmente suggerirmi come fare per :
aggiornare da una sottomaschera il contenuto di un campo in un elenco di
record determinato...
|
|
1 |
112 |
|
|
aggregate by
Brenda @ AIM
I used the COUNT function in a query to count the number of fields. I gave
it the name COUNTOF.
Now I want to make a query from that query and I try to select...
|
|
6 |
141 |
|
|
|
|
4 |
939 |
|
|
|
March 25th, 2010 03:26 PM
by KST8WCT
|
8 |
309 |
|
|
Aggregate count function by
Chris Motherwell via AccessMonster.com
I've created a query that counts the number of records based on a criteria of Yes or No (for a Yes/No data type). Is there any way to have the results display...
|
|
4 |
156 |
|
|
Aggregate Error by
Rpettis31
I am getting an aggregate message I am trying to pull the records of the
latest retail price by the date. Not sure what I am doing wrong.
SELECT item.item,...
|
|
4 |
150 |
|
|
Aggregate Expression error. by
Roger Twomey
I am getting this error:
Error: Tried to execute a query that does not include the specified expression as part of an aggregate expression
From this...
|
|
3 |
180 |
|
|
Aggregate function by
Amour
Hi I am new to Access and I need help! I am trying to create this query and
so far this is what I have:
SELECT Sum() AS Total, tblAttendan.TRVL_START
FROM...
|
May 7th, 2007 08:25 PM
by Amour
|
4 |
97 |
|
|
aggregate function by
samuel
i import a table with this value as the timestamp (seen as a text data type)
2005112602465800
i want a query to extract the month..
Date:...
|
|
8 |
103 |
|
|
Aggregate function by
Greg
I need some general guidance on how to approach a problem I can not
personally solve.
Each month I recieve an excel row with about 40 columns in the row.
I...
|
April 3rd, 2009 02:25 AM
by Greg
|
2 |
87 |
|
|
Aggregate Function by
virtualkeeper via AccessMonster.com
Hi all. I've tried finding an answer to this and can't find one somewhat
close. I'm getting an "You tried to execute a query that does not include...
|
|
3 |
83 |