Queries :: Calculate The Number Of Successful Backups Within A Window

Oct 16, 2014

I receive a report daily. From this report I need to calculate the number of successful backups within a window, and number of successful backups outside a window. The window is 7:00 a.m. The column contains date and time (10/15/2014 7:00 AM). Right now I have written the following query =Date() And > #7:00:00 AM#

I do not get any results even though there are 79 records that fit the criteria.

View Replies


ADVERTISEMENT

Queries :: How To Calculate Number Of Weeks Between Two Dates

Jun 25, 2013

My database includes two separate dates related to a vehicle purchase and default payments resulting in repossession. I need to find out how many weeks passed between those dates.

Example:
03/14/12 Date of automobile purchase
06/06/13 Date of last payment before default

How many weeks in between? And then I need to average all of those figures so my company can see the usual week-term time frame that our customers are defaulting and getting repossessed.

View 5 Replies View Related

Queries :: Run Query On Successful Login

Apr 3, 2013

I have created my own login forms using VBA Language, however I now want a query (Query A) to automatically run, to update data from a linked table (Table A) to a table that is editable (Table B).

View 4 Replies View Related

Queries :: How To Calculate Number Of Workdays In Access 2013

Aug 11, 2014

In the attached image I was trying to calculate number of working days(throughput) b/w item received_date and item_released date by using datadiff with "w" interval . but if I use "w" interval it brings value zero .but if I use "d" interval then it brings result with inclusive of Saturdays and Sundays.i don't need that.

How to calculate the number of working days exclusive of Saturdays and sundays.

View 1 Replies View Related

Queries :: Extract Or Calculate Number Of Records In A Sequence

Jan 4, 2014

How to extract or calculate the number of records in a sequence - e.g. in a table/query ordered by ID and date, the number of consecutive records by date for a given ID that have a value >= 50 in a given field. Is there a way of doing this purely within a query, or would I have to resort to a VBA loop through a recordset and keep a count of the consecutive records that match that criteria?

View 3 Replies View Related

Queries :: Calculate Number Of Days Between Two Dates Using IIF Statement?

Nov 21, 2014

I'm trying to calculate the number of days between two dates using the iif statement

Fields:
[LDW] "Last Day Worked"
[ReturnedDate]

DESCRIPTION: If ReturnedDate is null, then calculate the datediff "d" between LDW with Now(), if not, then calculate the datediff "d" between LDW with ReturnDate.

I tried this but it didn't work at all.

Days Absent: Iif(isnull([ReturnedDate],(DateDiff("d",[LDW],Now())),(DateDiff("d",[LDW],[ReturnedDate])))

View 2 Replies View Related

Queries :: Calculate Number Of Mountpoints Appeared In Table

Feb 15, 2015

I want to count number of mountpoints appear in the table.

As below sample table,
- Different mountpoints will appear, based on number of server using it. As you can see, the mountpoints will have repeating name based on number of server using it.
- The Count_Mountpoints will calculate number of total Mountpoints appear in the list.

MountpointsUsedbyCount_Mountpoints
/a/ins2server12
/a/ins2server22
/a/ins1server31
/b/ins2server31
/b/ins1server41

I only managed to get number of TOTAL mountpoints.... but by individual's mountpoint total count...

View 2 Replies View Related

Queries :: Calculate Total Number Of Days Between Two Dates In A Query

Feb 18, 2015

Basically I have a report that shows any 'Issues' that wasnt closed within the KPI Target.

I have the report working, but I simply want to do a count of how many days the observations overran the 'Target Date of Closure'.

The report also shows observations that are not closed but passed their Target Date of Closure. These observations will not have a 'Actual Closure Date', but I would like to still have a count of how many days its overrun closure.

This is a formula I tried to piece together but obviously not correct as it's not returning anything;

IIf(IsNull([Issues]![Actual Closure Date]),DateDiff("d",[Issues]![Target Date of Closure],
Date()),DateDiff("d",[Issues]![Target Date of Closure],[Issues]![Actual Closure Date]))

View 2 Replies View Related

Queries :: Count Same And Differences / Calculate Percentage Of Number Of Same Over Total Amount

Jul 9, 2013

I am trying to count how many of the "same" and "differences", as well as calculate the percentages of the number of "same" over the total amount. To clarify, I work at a nursing home, and I need to calculate the number of people who were admitted to our facility and then to the hospital for the same diagnosis, and a different diagnosis. Then, out of the total number of people who were admitted to the hospital from our facility, I need to calculate how many of those people had the same diagnosis or a different diagnosis.

Also, I need to categorize these diagnosis by each type of diagnosis.

View 14 Replies View Related

Queries :: How To Insert A Prompt For Number In A Query To Calculate Against Another Field In Query

Jul 15, 2014

I have a field that is giving me the number of business days between a period of time and then I want to subtract that number - the person's PTO time to see the actual days they were available...when I simply type the number in (see below) it works great but I want to set up a prompt that will ask me how many PTO Days to calculate as it will be different for each person I am quering...is this possible?

View 9 Replies View Related

Who Is Making My Backups

Apr 14, 2008

:mad:Is there anyway, I can tell who is making my backups. Is there any thing I can use to find out who is creating a backup. I have sent out emails to the users, but no one will confess who is doing yet. I have 200 users now. I have talk to our IT people, they mention it would take a lot of there time to track it down.

Does anyone know if there anything I can do?

Thanks

View 14 Replies View Related

Batch File Datbase Backups

Feb 7, 2006

hi all,

i want to create a batch file that basically backs up the database file i want into a folder as follows

x:ackupsdatabase020206db.mdb

i know that the command to create the folder is mkdir but i want to know how to integrate the data into the folder name so that this batch file can be run in windows scheduler and i dont have to worry about it overwriting the existing folder name.

any ideas?

View 1 Replies View Related

How To Create Backups/failsafes For Replication Manager/A97?

Jan 22, 2007

I have tentatively gotten an indirectly synchronised database system to work on a testing basis, in the following way:

1. Design Master - resides on network.
2. Replica Master - replica of master, resides on network
3. Local replica on the windows desktop of my laptop (as one of few folders with write authority). These three are managed by a synchroniser running on my laptop.
4. Other people (3-6) also have synchronisers running - managing the Replica Master, and a local copy on their desktop only.

This appears to work. It was done as we did not have access to get a synchroniser process running on a server, just folder access (I am amazed IT accepted this without oversight, anyway..). I would be happy to describe the procedure.


However, does anyone have any advice on potential things that could go wrong and how to avoid them? What problems could crop up? I don't believe database size would be one of them. How about backups? I know that the network is backed up daily and can be restored to any day - but would this method of backup create any problems if restoring? How rare are collisions/conflicts?

Also, is there any limitations to using the Compact utility in Access on either the replica master on the design master? Would this cause changes to get lost?

Would be grateful for advice.

Edit: Addition, just as I was submitting this, my synchroniser appears to have gone into a loop... From the log file:


Time = 2007-01-22 01:23:55 PM
Log Type = Close exchange
Replica = \afsukhofs02N_Dept[Folder names]Replica master.mdb
Exchange ID = {D4C646CE-140A-4DE0-B164-FE924A44C7A3}
Result = Failure

Time = 2007-01-22 01:23:56 PM
Log Type = Cancel exchange
Replica = \afsukhofs02N_Dept[Folder names]Replica master.mdb
Exchange ID = {D4C646CE-140A-4DE0-B164-FE924A44C7A3}
Reason = More than one synchronizer is managing the replica


This looks to be a problem... Is it caused by having multiple synchronisers managing the same replica? Does it work to set them to manage the local one only? Advice GREATLY appreciated. :P

View 1 Replies View Related

Calculate Number Of Days

May 4, 2006

In a database, I have the following date fields that I use to track projects that start and stop.

START1
STOP1
START2
STOP2
START3
STOP3

Is there a way I can use a query to calculate the total days the project was worked on? For example if I enter 1/1/06 in START1, 1/10/06 in STOP1, 2/1/06 in START2 and 2/15/06 in STOP2, 3/1/06 in START3 and 3/30/06 in STOP3, I need to calculate the total days. I need it to work regardless if there are 3 start/stops, 2 or just one start/stop.

I really appreciate the help.

Jim

View 14 Replies View Related

Calculate Number Of Animals & Runs

May 4, 2006

I own a kennel and was wondering if there is a way to put in 2 different dates and get totals of animals during that time and totals of kennel runs?
Thanks.

Sorry, my reservation table includes Kind, New (y/n), Owner's Name, Pet's Name, Date In, Date out, Price, # of Units needed, and # of dogs. I need to put in dates ie: 5-10-06 to 5-25-06 and get a total of dogs and a total of units so we don't overbook. When I made this program I have little idea of how to do it and now years later I'm trying to tweak it. Thanks again

View 14 Replies View Related

Calculate Age Using Persons Identity Number

Apr 25, 2012

I am using 2010 and have a bound field called Policyholder ID number in a table called Policy Information. I would like to calculate how old a person is by using the identity number which is 13 digits (South African ID) and the format is as follows - 7009215069084. Using the first 6 digits this person was born on 21 Sept 1970 and is 42 years old ( Current year of 2012 minus year of birth of 1970 = 42)

How I can include a calculated field so once I type in the identity number the age of the person reflects in a field called Current Age.

View 13 Replies View Related

Many-to-many Relationship Not Successful

Jan 18, 2005

Hi,
What looks simple is not turning out that way!
In our organisation a country may have one or more (often just two) provinces. Some provinces have one or more countries (as many as four). As an example, Philippines South province may have that part of the philippines to look after and Pakistan as well. The country (philippines) has two provinces, one north one south. The south has part of the philippines to look after plus pakistan. Clearly, then, a many-to-many relationship?
In due course I want to be able to pull out information relating to the country (e.g. Philippines) from either the north or the south province....the country info will be the same, but the province info will be different.
But I keep getting a one-to-one resulting from the following tables, which was the way I thought I'd need to create the many-to-many relationship. I'm beginning to think it mightn't be M:M after all!

COUNTRY
countryID (text type, since no names repeat)

PROVINCE
ProvinceID (text type since we use a 3 letter code eg FIN stands for Philippines North FIS for Philippines South)

COUNTRYPROV (link table)
ProvinceID
CountryID
I assumed that to relate the first two successfully, I create a link table by taking the two primary keys above and putting them into a third table, right?

But for some inexplicable reason, I can't then get PK countryID to relate to FKcountry ID one-to-many. It comes up as one-to-one. Similar when I drag PKprovince to FK province in the link table.
I'm obviously missing something very simple but what is it?
Julian

View 3 Replies View Related

Calculate Number Of Entries By Year And Frequency

May 2, 2006

Hi, am sure this is simple....! Can't find a solution.

I have records which have YEAR and APPARATUS as two of the fields. All I want to do is write a query which displays all the records chronologically by YEAR then within each YEAR to group them by the biggest subset according to APPARARTUS.

Therefore if there were 20 people who used Motorised equipment, 15 who used electrical and 10 who used gas, the records would be grouped in that order. Thus showing the pattern in change in use of specific apparatus over the years.

Why can't I DO THIS!!??

aLI

View 3 Replies View Related

Reports :: Calculate Number Of Days Between Parameters

Feb 6, 2014

I have a contract management database where contracts have a start date and an end date. I also have a date parameter set up whereby I can show live contracts between overlapping records.

I want to be able to count the number of days for each contract that is live between the dates of the parameters.

For example my contract might run from 1st to 30th November but I might want to report from 10th October to 10th November so the number of days I need the query to return is 10 days as my contract is not live before the 1st November. Or my query might run from 1st October to 31st December, then I would need it to show 30 days as it covers the whole of this contract.

View 3 Replies View Related

Modules & VBA :: Calculate Number Of Unique Days

May 9, 2014

My table : Id Start End

1 2013.11.20 2014.01.10 2 2014.01.17 2014.01.30 3 2014.01.06 2014.01.27 4 2014.02.04 2014.02.23 5 2014.02.07 2014.02.17 6 2014.02.21 2014.03.08

How to calculate total number of unique days? Date ranges are overlapped.

View 7 Replies View Related

How To Calculate Number Of First Letters Of Names In A Field

Sep 9, 2011

how to write out the query Im trying to create so I'll create an example:

Field: Drivers Names
I want to know how to create a query that will calculate the # of drivers names which starts with, A, B, C etc.
I want my query to be:

Drivers names first letter # of first letters
A 10
B 19
C 15

how I can create such a query

View 10 Replies View Related

How To Test If Delete Successful

Oct 18, 2013

I have some code to delete a record from a table, which does not delete the record, presumably because of referential integrity settings. That is fine of course, that's what should happen. However I want to be able to notify the user if a delete did not succeed. How can I check this? I tried this code, but it did not return an error.

Code:
strsql = "DELETE * FROM " & tblAddress & " WHERE GenAddressID = " & Me.tb_edtID
Err.Clear
CurrentDb.Execute (strsql)
If Err.Number <> 0 Then
MsgBox (Err.Description)
End If

View 6 Replies View Related

Tables :: Calculate Number Of Days From Two Dates In Table?

Apr 20, 2015

I am making a basic hospital management system in Access 2013.I have two tables named "Bed" and "Receipt". Bed(BedID,AssignedDate,PatientID,DischargeDate,Bed Charges) Reciept(ReceiptID,PatientID,BedCharges) I want to calculate "BedCharges" by calculating the number of days using "AssignedDate" and "DischargeDate" and then multiplying with a constant amount of charges per day. Also the BedCharges calculated in "Bed" Table also needs to be in the "Receipt" table. How can I count the number of days and then calculate the "BedCharges" in both the tables?

View 8 Replies View Related

Modules & VBA :: Calculate Integer Number Difference From Two Dates

Sep 20, 2014

Basically, I am trying to calculate a integer number difference from two dates (TAT = Due-Date - Result_Date). The number is calculated and excludes weekends and ideally holidays (for that I have a tblHoliday but not sure how to use it). The function below seems to calculate a number but doesn't exclude weekends.

For example, if Due_Date is 9/26/2014 and Result_Date is 9/30/2014, then TAT is calculated to be 5 (should be 2).Since 9/26/2014 is a Friday only Friday and Monday are used in the calculation.

Code:

Option Compare Database
Public Function WorkingDays(StartDate As Date, EndDate As Date) As Long
Dim intCount As Long
intCount = 0

[code]...

View 1 Replies View Related

Forms :: Requested Change In Table Not Successful

Mar 31, 2015

I'm getting an error message as shown in the screen shot I've been trying found where the error is in my relationship but just can't see it.

View 1 Replies View Related

Forms :: Linking Successful Login To A Form

Jan 3, 2015

i have created a login page and i have coded it but i do not know to set coding up so that it results in a linked form to open up..( main menu)

View 8 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved