Search results

I am trying to calculate the number of occurrences in a month. Collum B holds the date, I want to work out how many times something has occurred in a month. So if there are 9 entries for January and 4 for February I want to be able to calculate this, however, I cannot work out a way to do this...

I have a sheet that tracks incidents and I need to work out how long between the incident occuring and how long it has taken for it to be reported, ensuring it's within our KPI etc. However I have the following forumla: =((F2+G2)-(B2+C2))*24 which does what I want it to do, however what I would...

I think I get what your saying... So how would I write the formula?

I have the following: What I want is if the Highlight Collumn has Yes in it, to highlight that row. I have gone to conditional formatting selected Use a formula to determine which cells to format however I cannot work out the formula to select if yes? I have tried IF(E2="Yes") and this...

Thanks CJ. The cell references should always remain the same the only thing that should change on each row is the date. Hopefully this makes more sense:

I currently have the following formula which works fine. =COUNTIFS('Patient Summary'!B6:B454,"6/7/2016",'Patient Summary'!C6:C454,">=00:00",'Patient Summary'!C6:C454,"<01:00") However when I copy the formula into a row below to do a different date it changes the code for the rows to look a...

I have a SS that works out ages of those in the SS. DOB is column F and Age if column G. In column G i have the following formula =DATEDIF(F11,TODAY(),"Y") However if column F is empty it automatically puts 116 as the age. Is there a way to only enter the age if DOB is present?

I am moving all of our training records from single sheets of paper to one excel workbook. What I have is two columns per qualification, one that is for date gained and one for expiry date (3 years from date gained). The expiry date I have the following formula =EDATE(G3,3*12) However where...

Hi All, I have a query which shows data about certain checks that are carried out employees. One of the fields is Expiry Date of the check. What I want is for the query to show only records that have a expiry date which has expired or is going to expire within the next three months of today's...

Is there a way that to use a database for the first time the user has to enter an activation key / serial number and then each time after can use it normally? I've had a quick search for activation key and can't find anything :rolleyes:

So I have a database where I enter Cost of Product and the the Postage Cost. I then want it to calculate the total cost. These three things are fields in my table: Cost Postage Cost Total Cost How do I get the Cost & Postage Cost fields to add up to put the total into the total cost cell? As...

I would also like to know how to send an e-mail to the address that is stored in the table if this is possible...

Two questions... 1) I have a form where orders are inputted. I want a button to be able to be clicked with will open a form based on the value of the autonumber (order number) how do I do this? 2) How can I get a report to be e-mailed to the address that is shown on the report (I enter the...

My mother has asked me to make her a Database which she can process orders through as her small part time home run business is getting a bit bigger. She wants a database which she can store products, customers and then orders. I have the following Tables with the following fields: Customers...

Okay so what would be the simplest way? What code do i put in the query? I also want it to add up on the form tho?

I want to add two fields in my table. One field is called Product Cost and the other is called Postage Fee. I then have a field called Total Cost. I want to be able to enter the Product cost and the Postage fee and the total to be added together in the Total Cost field. How do I do this? I am...

Hi There, I am probably being really thick. I have a table which has a feild called Percentage complete which is manually entered. However I would like a query which only shows me items that are less than 100% complete. I thought the query criteria would be <100% but that didn't work so I...

Good Evening, I am looking at putting in a timer function on my form. The form is for escalation call backs so we need to start the timer when starting the call back and end the timer at the end of the call back. What I would like is for a button to be pressed by the user and the system to...

Good Evening, I need some help with what I think is probably a basic query. I want to be able to enter a date range (a start date and a end date) for the query to show the data. I would like to use a form with two text boxes, one for the start date and one for the end date. What criteria would...

Hi All, I am just creating a web space for a local youth group. Only about 30 people with just basic information and links to downloads for letters that have been sent and a calender on the site. What I would like is a simple HTML code for a login page for the leaders to be able to download...