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 : New Users Forum Tools Search this Forum Feed Icon
  Thread Reverse Sort Order / Thread Starter Last Post Replies Views
Calculating Age in Access by forest8
Hi In my database I have 2 dates in my form: Current Date and Date of Emplaoyment. I would like to calculate how many years my employees have been working...
March 9th, 2010 04:56 AM
by forest8 Go to last post
6 222
calculating age in days by Greg Snidow
Hello all. I have read all the posts I could find dealing with calculating age based on a start date. I can't find anything dealing with calculating age in...
November 17th, 2005 06:47 PM
by Greg Snidow Go to last post
5 161
Calculating Ages by Graham
Have been following recent thread on calculating ages. I have a Club membership list, including a D.O.B. field. I wish to calculate the current ages of the...
August 17th, 2004 04:22 PM
by fredg Go to last post
1 104
Calculating an age that will never change Access 2007 by ccinseward
I need to calculate ages based on how old they were when they entered a program and how old they were when they completed the program. these ages don't need...
May 16th, 2007 04:26 AM
by B. Edwards Go to last post
2 80
Calculating an average in a report by Bailey
The current database I am working on has numbers entered into the form view. I need those numbers and the average of the numbers to show in the report view...
February 26th, 2006 02:44 AM
by Duane Hookom Go to last post
1 119
calculating between 2 dates by indigo993
I have created a fixed asset subledger which includes a purchase date and the lifetime of the asset (in months). At the end of each month I would like to...
October 16th, 2008 11:46 PM
by KARL DEWEY Go to last post
1 85
calculating columns (fields) by Dino
I'm trying to calculate columns (fields) in a query in Access. I have to be able to do this to display the correct data. My table looks like this...
February 17th, 2006 11:57 PM
by KARL DEWEY Go to last post
2 174
Calculating Differences in Times by JoLeigh
I need to calculate the time that it takes to complete an event; e.g., one field has start times and another has finish times. Each field is currently in a...
January 5th, 2006 09:49 AM
by Steve Schapel Go to last post
3 123
Calculating elapsed time by WKN
I am trying to calculate the elapsed time between between two time periods. The begin time in the afternoon (PM) of one day and the end time is the morning...
October 24th, 2005 02:57 AM
by WKN Go to last post
7 292
Calculating Fields by gp
I'm trying to populate a field based upon values is 2 other fields. I have a field DEGREES and I want to add it to the sum of the field MINUTES/60 to create...
February 23rd, 2010 11:10 PM
by KenSheridan via AccessMonster.com Go to last post
4 198
Calculating fields for Access by Galin
Hi all, I am trying to calculate two fields. I have six fields in query window... ID, PAY_CODE_1, PAY_CODE_1HOUR, PAY_CODE_2, PAY_CODE_2HOUR PAY_CODE_1 and...
May 5th, 2004 12:05 AM
by Marc Go to last post
6 812
Calculating how many enqiries there've been between two dates by Stephen Glynn
This sounds as if it should be simple, but it's thrown me. How do I write a query that just gives me the total number of enquiries I've received between two...
January 17th, 2006 01:24 AM
by Stephen Glynn Go to last post
5 96
Calculating in table field by :\(
Hi. I've created a field in a form that calculates the age from the birthdate of the previous field. But I would like it to figure in the table. All the help...
April 17th, 2005 02:14 PM
by Bruce Go to last post
8 124
Calculating Months by Kath via AccessMonster.com
I am working on exporting information from another system. One of the queries I need to write includes data from 15 months prior to present date. How do I...
May 13th, 2005 10:13 PM
by Douglas J. Steele Go to last post
1 127
Calculating Net Change by Needhelp1
I am fairly new to access programming. I have created a database of stocks and want to add a column for net change. The logic is today's close minus the ...
March 24th, 2005 07:20 PM
by Rick B Go to last post
1 100
Calculating no of weeks in access and flag recor if no of weeks is by MitziUK
I have set up a form which has a 'date on hire' and 'date off hire' field. I want to be able to say to the form, look at this record (hire no) if the date of...
September 30th, 2005 11:44 PM
by Ed Warren Go to last post
8 231
Calculating number of days by crybicki
I have fields Date obtained and date (today) and I'm having difficulty geting the field days - to work I put - in Default Value Saving error : The database...
November 30th, 2005 10:34 AM
by Ed Warren Go to last post
5 101
Calculating numbers by Etta
I am new to creating Access databases and need to know how to set up a way to track the number of documents issued to a department. That is, over the course...
June 6th, 2007 01:05 AM
by Etta Go to last post
4 71
Calculating numbers, part 2 by Etta
To Ken and others who can help... I tried to follow Ken's instructions (reprinted below) very carefully but I did not get them to work for me. Here's what...
(Multi-page thread 1 2)
June 30th, 2007 01:54 AM
by Etta Go to last post
18 169
Calculating numbers, part 3 by Etta
Although someone (ken?) responded to this question, I am unable to find the reply... Hi, Ken, I should have mentioned that I went with your suggestion of...
June 30th, 2007 06:02 PM
by Ken Sheridan Go to last post
1 75
Post New Thread


Display Options
Showing threads 2001 to 2020 of 17167
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 08:05 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.