A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Running & Setting Up Queries Forum Tools Search this Forum Feed Icon
  Thread Reverse Sort Order / Thread Starter Last Post Replies Views
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 Go to last post
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 08:52 PM
by Dale Fye Go to last post
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 Go to last post
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...
January 11th, 2006 09:54 PM
by Michel Walsh Go to last post
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...
September 14th, 2007 03:18 PM
by Michel Walsh Go to last post
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 Go to last post
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...
January 19th, 2006 05:29 PM
by Michel Walsh Go to last post
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...
July 14th, 2004 11:51 PM
by Douglas J. Steele Go to last post
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 05:11 PM
by Rick B Go to last post
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...
February 8th, 2007 11:56 PM
by madmax71 Go to last post
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...
October 19th, 2004 05:41 PM
by Lynn Trapp Go to last post
6 141
aggregate calculation works in select query but not an update quer by bicyclops
The below query works well as a Select Query. But when I turn it into an update query, I get a whole lot of nothing in the results. Interestingly, if I try...
May 27th, 2010 10:44 PM
by bicyclops Go to last post
4 891
Aggregate calculations on calculated query fields? by KST8WCT
I made a query that uses fields from multiple tables to calculate values for daily metrics. I need to present monthly totals of the data as sums and/or...
March 25th, 2010 04:26 PM
by KST8WCT Go to last post
8 292
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...
January 22nd, 2005 08:54 AM
by Chris Motherwell via AccessMonster.com Go to last post
4 154
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,...
July 23rd, 2009 05:36 PM
by Rpettis31 Go to last post
4 148
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...
August 17th, 2004 08:30 PM
by Roger Twomey Go to last post
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 Go to last post
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:...
December 28th, 2005 04:33 AM
by Marshall Barton Go to last post
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 Go to last post
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...
June 12th, 2006 04:51 PM
by virtualkeeper via AccessMonster.com Go to last post
3 83
Post New Thread


Display Options
Showing threads 2001 to 2020 of 43289
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:38 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.