Date Calculate

Calculate Between End Date And Next Start Date
I have a table that has the following feilds:

Person Start DateEnd Date
John Smith10/1/20061/14/2007
John Smith2/18/20075/31/2007

What I want to do is calculate the number of months between the 1st end date and the 2nd start date. Any ideas on how to do this?

Thank you in advance for your help with this!

View Replies !

---

Calculate Date Which Is On Every Wednesday
dear all

how to calculate a date which is falls on every wednesday using ms access

for eg

this week enter date : 05/03/2007 and then save

next week automatically display date : 14/03/2007

later next time, enter date : 16/03/2007

next week automatically display date : 21/03/2007


i don't think this is the right formula

=DateAdd("d",7,[run_date])

if i keyin run date : 03/03/2007
it will display using above formula : 10/03/2007
but i want display run date : 07/03/2007 ( falls on wednesday )

what if keyin run date : 05/03/2007
it should be displayed : 07/03/2007 ( falls on wednesday )

any other way the right formula


thanks in advance

View Replies !

---

Need To Calculate Weekend Date
I track my daily work in an access data base. very simple. each day I enter the date, activity, the person I was helping, and a value ie. 1.5 hours etc.

I might work on the same project many times that week, i.e. 1.5 hours on Monday, .5 hours on Tuesday, and 1.0 on thursday.

my new boss wants a weekly summary. so I need to create a query that would show the total for this activity 3.0 hours for that week. So basically at the end of the year, I would have a query with activities by row, weeks across the top i.e. 52 columns, and the total of the various activities summed up for each week.

I looked at all the standard date functions, and did not find a weekend type functions.

View Replies !

---

Calculate Rate Between Date
Hi All.
In my employee's table I have EmployeeName, Rate, Date and I need create query to calculate Rate for each eployee between Date if ration during this period of time was diferent.
Thanks.

View Replies !

---

Calculate Total Thru Date Value
Hi All.
I try to generate a report which calculate subtotal for patient AMOUNT for current year and total for whole period from first visit to current date. The result of subtotal =Sum(IIf(Year(Date()=[VisitYr]),[Amount])) is the same like total. What is a correct way?
Thanks.

View Replies !

---

Calculate Future Date
Hi, All...

Can someone tell me how to calculate a future date in a bound field on a form? The form includes "date created", "life expectancy" and "review date" fields, all bound to the same table. I want the "review date" to be calculated by adding the "life expectancy" (number field, in days) to the "date created" field. I found some posts that were similar but none using bound fields.

Thanx so much for you help with this...I've spent quite a lot of time trying to come-up with a solution...to no avail.

Thanx ;<)
Karen

View Replies !

---

Calculate Due Date On Form
I have a form (frm_Active) that reads from a query (qry_Active) based on a table (tbl_Data). The form/query/table has the following fields:

EVENT DATE
START_DATE
REVIEW_DATE
APPROVED_DATE
POST-REVIEW_DATE

When I add a new record, I would like for the default dates to be populated based on the EVENT_DATE. For example, if I enter 1/1/2006 for the EVENT_DATE, I want the

START_DATE = +7 days
REVIEW_DATE = +55 days
APPROVED_DATE = +60 days
POST-REVIEW_DATE +180 days

I tried to do this in the table as the "default value" and it would not accept it. I don't think I can do this in the query because the query is basically displaying the table and I want to be able to manually enter a different date if needed so it will be stored in the table. I tried this on the form in the "Default Value" field, but it is just blank when I enter a new record and enter the EVENT_DATE. However I am not sure I am entering the formula correct. Can someone tell me what is the best way of doing this and what the correct formula is?

Thanks,
Jim

View Replies !

---

Calculate A Date Based On Dropdown
I have a drop down box in my access database which I want to use to give completion dates to jobs, the drop down has three values:

Emergency
Urgent
Routine

emergency equates to 1 day
Urgent 7days
Routine 28days

I have had a dig in the help files and I can get the order completion date to show the terms emrgency, urgent and routine, however I nned to calculate the date, not just show the term, this where I lose track of how to get any further, I have searched the forum and cannot find an example, but perhaps I am not using the right search criteria, I have tried date calculation on drop down results etc etc and no dice, I am sorry if I am posting a question whichg has already been answered, and if anyone can post a link to a solution that would be great to.

Many thanks for your help this is my first post on this forum, but I am sure I will be here for a long tme to come access is fast becoming my life :D

again many thanks for taking the time to read this and I appreciate any help you can give me.

View Replies !

---

Calculate A Date Based On Dropdown
I have a drop down box in my access database which I want to use to give completion dates to jobs, the drop down has three values:

Emergency
Urgent
Routine

emergency equates to 1 day
Urgent 7days
Routine 28days

I have had a dig in the help files and I can get the order completion date to show the terms emrgency, urgent and routine, however I need to calculate the date, not just show the term, this where I lose track of how to get any further, I have searched the forum and cannot find an example, but perhaps I am not using the right search criteria, I have tried date calculation on drop down results etc etc and no dice, I am sorry if I am posting a question whichg has already been answered, and if anyone can post a link to a solution that would be great to.

Many thanks for your help this is my first post on this forum, but I am sure I will be here for a long tme to come access is fast becoming my life :D

again many thanks for taking the time to read this and I appreciate any help you can give me.

View Replies !

---

Calculate Warranty Expirary Date
Back on the development trail............

So what do I want to achieve?
I have a form frmHardwareEntry based on a query qryHardwareEntry which in turn is based on a table tblHardware.
I have a field in table hardware 'Date Purchased'.

Within the frmHardwareEntry I would like to add a field(s) 'Warranty' & 'Warranty Expirary Date'. So user enters date purchased, the manufacturers warranty period (1,2,3,4 or 5 years) then 'Warranty Expirary Date' auto populates...ooohh and an additional field that counts down the remaining time......'Warranty Expirary Date minus Date()'?

Advice warmly received. The DB is intended for the forum for others to make use of (currently on version 999!!!!). Will post when ironed out license allocation issue in the mean time thought the above would be a nice inclusion!
Thanks,
Phil.

View Replies !

---

Calculate An Age Based On Date Of Birth
This is my first post to this group. I am building a database for a charity event and need to calculate the age of a person based on the Date Of Birth field in the table and add that number to a separate column in the table. Also, need to calculate the age as of a certain date (the beginning of the event). Thank you for any help.

Larry

View Replies !

---

Calculate Mulitple Dates Listbox From A Single Date
Hello,

I am trying to create a listbox that shows "calculated" dates for a two week payroll. I have a field in a table that is set to a start date (05.31.05) and another field that specifies the number of days between dates (14). I would like set a listboxes recordsource to show the start date and then calculate the next 4 dates using the first date (05.31.05) and the range (14) without actually storing any dates in the table. I can figure out how to do it if the values are stored, but I just want to know if this is possible to get the results another way.This may sound crazy and unecessary, but I want to know if this is possible without storing values in the table.

Listbox values:
05.31.05 - (first date from table)
06.14.05 - (first date + 14)
06.28.05 - (first date + 2*14)
07.12.05 - (first date + 3*14)
07.18.05 - (first date + 4*14)

Is this possible? HTMS. Thanks.

View Replies !

---

Calculate A Value
How would i go about getting the field 'GMargin' (Gross Margin) to be calculated from subtracting 'SellingP' from 'PurchaseP' (Selling and Purchase Prices)?

How do i do this? Help me please :)

View Replies !

---

Calculate
I have a field which I enter a short time such as 3:13, 5:45, etc

Now i am creating a report which at the end of the report I would like to include an unbound text box, which displays the total amount of time for that field (pls note that the total will never exceeds 24 hours) What is the best formula to use in order to calculate this ?

Cheers

View Replies !

---

Calculate Hh:mm To Mm
Hello,
I am trying to sum minutes from a database using an Access query, but the format in the database is hh:mm. I know the query to use in Oracle:
ROUND(SUM((substr(actual_time,1,(instr(actual_time ,':' )-1))) *60 + (substr(actual_time,(instr(actual_time,':' )+1),2)))
but not sure of the syntax to use in an Access expression.
Any ideas?:confused:

View Replies !

---

Excel Can´t Calculate.
HI,

Excel is having difficulties calculating a workbook of mine. It complains about cirkular references, so I had to set the iterations manually.

The workbook holds about 5000 records and I´m using a cosinus function.

The thing is I don´t know what to do. Excel calculates the workbook, but it doesn´t do it right. What setting should I use with the iterations?

I´m thinking of running it in excel 97. Will that help?

I really need to be able to run this workbook. Does anyone have an idea?

Fuga.

View Replies !

---

One PC Not Able To Calculate Formulas Ect.
Hello, I didn’t know how to explain this or where to post this but here we go! I have two databases and one of the PC's here at work can’t use some of the items in the database like on one of the databases there is some formulas in text boxes and that PC won’t calculate what’s needed in them and every PC in the plant will except for this one PC. Also the one PC won’t bring up the Allen Browne's Calendar. When you press the start or end button to bring up the calendar it never pops up but if I enter the start date and end dates and use it that way ect then it works. I have no clue why this is just happening to this one PC. Any ideas?

View Replies !

---

Calculate Age Using Queries
i have a table with fields "[DATE OF BIRTH]", "age", "temp-age"

i have a query that calculate the age:
example; the query will get user to input the "temp-age" and upon "temp-age" is input and "ok" on the query, it will calculate a person's age and store the value inside table "age".

however, the calculated value for the age have some data problem. for example, when a person whose age is yy:mm 24:05 the age inside the table will be 1924:05. there will be a additional "19" at the age.

what cause the additional "19" problem?
---------------------------------------------------------------------
my query in design view is like this; (see attachment)
it uses " [temp-AGE]-[DATE OF BIRTH] " to calculate the age and store into table "age".

View Replies !

---

Calculate A % Of Total.
I have a query that returns a number of calls recieved of a certain type for each week of the year. Wnat I want to do is calculate the % of those type of calls of the total calls for each week. Below is my querey

SELECT datepart("ww",DateLogged) as Week_Number,
COUNT(CallType) AS call_count,
FROM tblLog
WHERE CallType = 'Software/May-PS' OR CallType = 'Report Regeneration-PS' OR CallType = 'Training/Info-PS'
Group By datepart("ww",DateLogged);

View Replies !

---

Calculate Months
Hello,

I'm trying to calculate months not days between

EX: 1/1/06 to 6/30/06
I tried to use end date (-) begin date, but is only give me the difference in days. What expression do I use to get 6 months?

:confused:

View Replies !

---

How To Calculate Total?
Hi, i'm trying to calculate the amount of employee for each company giving me a total in the queries.. how do i go about this? I'm not an person who uses Access to solve this. I have amount 20 Companies stored and over 800's employee.. Here are the field in the table:EmployeeIDEmployeeNameNumberofEmployeeThanks! Hope this helps.

View Replies !

---

Calculate Commissions
Hi

I am very new to databases, and think i am a bit over my head. I am doing a database for vacation rentals, and am trying to calculate commissions, basically i wanted to have a set of checkboxes, labeled 10%, 15%, 2.5% and $25, with any combination of these checkboxes being able to be checked.

i want the query to work like this:

If the 10% checkbox is checked i want the query to take the SubTotal for the reservation, and calculate 10% of that number. if the 2.5% checkbox is also checked, i want the query to calculate 2,5% of the reservation and add it to the commissions total (10% + 15%)

I think(hope) that i explained that clearly? Can this be done?

Thanks for your help!

Ben

View Replies !

---