Hi, I am creating a table in 07 and I want my table to be able to calculate the difference between two amounts. I have the column "price" which shows the total amount, another one called "money paid" which shows how much of the total amount they have paid so far and the third is "money owed" which is the difference that i want to be calculated automatically.
Do you know any way to do this??
Hello:
I have a report with three text boxes:
Box 1 contains an employee's total weekly hours in hours and minutes: 40:00
Box 2 contains the actual total hours worked for the week: 35:30
Box 3 is the difference between Box 1 minus Box 2
I tried all the date/time functions to calculate the difference between Box 1 and Box 2 and none of them worked. I keep on getting an error message. Does anybody know how to calculate the difference between two sets of time (in hours and minutes)?
Thank you in advance.
I have a [Time Job Started] field that is auto populated with now(). which has input of 1/29/2014 11:02:02 am. Then I have a [Time Job Ended], typed in by user that has input of 6:00 pm, no date value. Cant really do the date() + Time Job Ended, because the date can range since times can go through midnight.
I am trying to calculate time duration. DateDiff("n",[Hot Calls]![Time Job started],[hot Calls]![Time Job Ended]) if this formatted as "Short time" it returns 0:00.
I want to report this as HH:MM. so the result should be 6:58.
I'm trying to add a calculated field which will be the time difference between two other date/time fields.
When I try to make a Calculated Field it does not recognize the DateDiff command.
Is there a preferred method to create a calculated field based on date/time differences? One would think this would be an easy thing to do.
I am new to Access. Is there a way to do a automatic calculation in a table field?
eg fieldA divided by fieldB and have the result show up in fieldC
Thanks
I want to add three fields in a table namely from, to and diff .
How to add them in a form so that I can enter
The time in (xx:xx) 24hr format in the "from" and "to" fields and calculate and save the time difference in minutes to the "diff" field automatically.
I am using access 2010.
The project I'm working on is an action list with the following tables;
itemnumber - autonumber PK
originator - text
dateentered - date/time
actiondescription - text
assignedto - text
targetdate - date/time
forecastdate - date/time
actual date - date/time
remarks - text
due - text (not sure if this will be correct)
Basically, when a new task is entered, all info will be manually filled in except last 3 fields. targetdate needs to be locked after entry, and forecastdate initially set to targetdate.
"due" should show how many days between dateentered and forecast date, and preferably update everytime the DB is opened. IF the current date is beyond the forecast date, "due" should read "OVERDUE".
Changing forecastdate would obviously reset the "due" field to show how many days left to complete. If a date is entered into actualdate, then "due" should show COMPLETE.
Reports will be generated based on what is coming due, what is over due, and not show what is already complete.
Currently I have a form with these variables
- Assets
- Shifts
- Machine Offline Date
- Machine Offline Time
- Machine Online Date
- Machine Online Time
Now I have 82 assets in the factory and 20% of those machines run 3 shifts. Each shift is 8 hrs.What I have already done is allocate shifts per asset e.g. when I pick Asset (a) in the Asset combo box, in the shift box it will automatically generate 2 or 3 dependant on what I have set.
If an asset runs for 2 shifts, it would mean that, that asset is operational/running from 0700 - 2300 or 7:00am - 11:PM also if an asset runs for 3 shifts it would mean that, that asset is operational/running from 0700 - 0700 or 7:00AM - 7:00AM
Scenario A: Machine (a) breaks down at 1700/5:00PM on the 10/7/15 and was back online at 12:30 on 11/7/15, This machine runs for 3 shifts which would mean in the "Breakdown Downtime" the result should be 19.5 hrs
Scenario B: Machine (b) breaks down at 1900/7:00PM on the 10/7/15 and was back online at 10:00AM on 12/7/15, this machine runs for 2 shifts which would mean in the "Breakdown Downtime" the result would be 23 hrs.
I would like to make this an automatic calculation, Is this possible?
Hi all, I don't really have a problem for anyone to solve but I do have a question as to a difference I found between Access 97 and 2000.
I am in the process of converting some 97 databases to 2000. I am doing this by simply using the convert option within Access 2000. I thought things would have been pretty straight forward, but the first database I converted didn't work the same way as it did in A97. The first difference I found is that I have a button on a form which has the following code.
Private Sub cmdSearchAM_Click()
DoCmd.ApplyFilter "qryAMSearchFilter"
Me.AMFilterInput = Null
End Sub
The query "qryAMSearchFilter" looks at the combobox AMFilterInput which is on my form. In A97 I could simply pick different names from the combobox and then each time I clicked my button it would filter the form correctly, however in A2000 this isn't the case and I have had to do the following.
Private Sub cmdSearchAM_Click()
Me.Requery
DoCmd.ApplyFilter "qryAMSearchFilter"
Me.AMFilterInput = Null
End Sub
Would somebody be able to explain to me why this is now happening and if there are any other things I should be aware of when converting to A2000 from A97.
If anybody thinks my solution to my initial problem is wrong could you let me know, even though it seems to work I don't know if it the appropriate fix.
Cheers,
Steven.
I know and have worked with MS Access for over 3 years now.
Just would like to know if there is very much difference between MS Access and SQL Server. Are they similiar or are they completely different .
In terms of designing forms, reports, sql.
Appreciate some feed back and also where I could view or look at sql server.
I have a query that is looking to calculate staff absence.
Absence Start date & Return to work date
Looking to calculate number of days (not a problem) but to exclude weekends ie saturday and sunday ????
Not sure if this can be done --- any assistance would be greatly received.
thanks and regards
ian watson
Yarm Cleveland UK
I have a table/form that has name, a specific date, and an email address. I would like that when the specified date matches the current date, it will automatically send an email to the address specified with a pre-built message. Is this possible? If so, how?
Thank you.
Hi everyone,
Is there a way to automatically shut down Access after a given amount of time?
I have an Access application that runs across a network. Access is the front end of a SQL Server 2000 database.
Some of the users forget to close their application at night when they leave for the day. When I come in in the mornings, I like to run the Compact and Repair, but can't because someone is still logged in. So then I have to go to each and every computer to see if they are still logged in. By the time I vist each computer, the morning is almost started and people ARE logging in for the day.
So I'm hoping to find an application that will automatically either log each computer off across the network, or that will log the application off of each individual computer after a given amount of inactivity.
Thanks for your help...
Hi all,
We have a database here at work where we keep records of client marketing campaign materials, which lets us know when said materials have gone to print and such. The problem is that we've always had to type in the client info manually because none of us can seem to find a way to automatically update new client info in sequential order. We have to keep a list of the clients as well as the alphabetical code they've been assigned to, which has become very problematic, since everyone is not on the same page. I'll show you what I mean - below is an example of client names and the codes they've been assigned to:
(Existing client)Cleary - AFB
(New client) Greenville - AFC
(New client) UAW-DC - AFD
And so on....
If anyone could help me with this, I'd greatly appreciate it. Thanks for listening.
-Zoob
Hi, I am a longtime Excel user, and am now migrating some work to Access.
I have 2 fields dealing with dates in the format mm/dd/yyyy hh:mm, OPEN and CLOSE
I'd like to get the difference between the two in hours, but I have no idea how or where to do this in Access. I'm assuming it is put into the queries, but it would be easier if I could just put it in the table.
Here is an example
1/1/2008 1:00 1/2/2008 2:00
I want the result to be "25"
Thanks in advance!
I am using Access 2007 database in work environment. When one of my colleagues tried to update some records in a table, it created a backup of the database.
The issue is that the size of the actual database is much smaller than the size of the backup. However all the data are present and I don't think any data has been deleted.
But I don't know why there is a difference in size?
Some of the tables in the database are linked from MS SQL Server.
I have an excel sheets with tables (Numbers). I have inserted this excel files into PPT. I have a button on my page. I have linked the PPT path to that buttom (using hyperlink). So, when I click the button the PPT which contains the excel charts is opening (this is good so far)The data in excel sheet is used by many people and they can change it.
When in Access the ppt is opened then it's showing the old data but not the new modified data. (We are right clicking on the ppt table and then updating the links)We just don't want to do that as we have lot of tables in PPT.when we open a ppt via access then it should automatically update itself in the backend and should open with the new values.
How can I create a database which automaically inputs the date and time when a value is placed it another collumn.
e.g 3 collumns= name, date + time
When the name is inputted the present date and time are assigned to the name.
If the name is changed then the date and time are updated to the present.
Many Thanks.
J
I have a table in Access with a field End Date with couple of other fields like Company Name and Description associated with the End Date as one record. In other words, one record has fields Company Name, Description and End Date.how could I get Access trigger an email automatically to a set of people let's say a month before the End Date is approaching. If the End Date is 30/4/2015, I would need Access to be triggering an email to the recipients on 30/3/2015.
View 3 Replies View RelatedI am working on an attendance file. I have created one MS access form and one excel sheet. On MS Access sheet I have Student ID, Date and Value. ON excel sheet I have Course, Student ID, NSN No and date.
I want data to be automatically appear on excel sheet from ms access form and after updating it or after transferring data i want these fields again empty and ready for next entry.
For example, If I type value .5 in ms access under 01-Jan-2014 for Student ID 1200001, value .5 should automatically appear in cell in ms excel sheet infront of same id (1200001) and under same date (01-jan-2014).
I need to import 15 csv files into access every month. I have location of all those files listed in a table in the same access DB but i'm not sure how to incorporate them in a macro I have written to import one of those files:
Function Macro_TransferCsvFileTo_RatesTradeData()
On Error GoTo Macro_TransferCsvFileTo_RatesData_Err
DoCmd.TransferText acImportDelim, "Import_Spec_tbl_RatesData", "tbl_RatesData", "c:Documents and SettingsaggauraDesktopWIPXMLDB_JOH_FI_2011123 0.csv", True, ""
[Code] ....
where c:Documents and SettingsaggauraDesktopWIPXMLDB_JOH_FI_2011123 0.csv is the file name I want to be replaced by each of the file listed by me in the other access table.
I created a Tracking System and would like to send an automatic reminder to the person the ticket has been assigned to, using the due date and the text message in the field "reminder message". Once the message send, I want the database to recognize and not send it again. I want the database to send a new message if the due date has changed.
View 3 Replies View RelatedI'm trying to use Access to send an automatic email reply upon receiving a request from a customer/employee, telling them that their request has been received and this is the tracking number and the due date of service completion. How can I do that? And I want it using Outlook because all the contacts are saved in Outlook and all emails sent and received through Outlook. And the version is Access 2010.
View 3 Replies View RelatedWhen I import a column from Excel into a new table in Access using the Docmd.transferspreadsheet function, Access automatically assigns a field name of "F1"; and if I try to import a range of columns (Eg A1:B10), then Access saves them into a table with 2 columns with field names "F1" and "F2". The table is created as part of the Docmd function, and so I don't have control over the field names.
Is this going to always be the case? Can I depend on Access to always use this naming convention? Because I am about to start writing more code that will depend on these field names.
Just wanted to confirm which is the best way to create an automatic back up of a access DB. (Split DB, backing up the BE - Access2010)
Firstly I was thinking of just creating a batch file to copy the file to a new source directly with a task scheduler set up.
Ideally I'd like it to run daily and have the date of the back up added to the end of the filepath.
i Want to make something in access for my job but i dont know how ... I have many years to use this software.
The idea is to have a FORM with many boxes .... http://img329.imageshack.us/my.php?image=58740895rq8.jpg
when i press product 1 and then product 2 i want to calculate, to give me the sum ....... i ll need to have many products i want to make calculations show i ve create one table from which i want to take the prices ...is it possible or it can be with an other way ?? :confused:
http://img525.imageshack.us/my.php?image=90673797oy7.jpg
Does anyone have a similar to saw me? :o
I need ideas !!!!
thanks!!!!