Search results

24/09/12 Team 1 = 90% 21/09/12 Team 1 = 85% 24/10/12 Team 1 = 93% 25/10/12 Team 1 = 70% 24/09/12 Team 2 = 50% 22/09/12 Team 2 = 68% 25/10/12 Team 2 = 91% 28/10/12 Team 2 = 99% 3 fields Date, Team, Average. How do i get the average per month of each team please

Is it possible to export a report with a click of a button AND have to automatically password protect itself.

How do I disable a user from using most of the menu options in a frontend database, specifically the Copy, Paste, Export etc.

Hi all, Im not into SQL or anything advanced but am stuff on this query. I have a field called 'Cleaning Poster' which is a yes/no field and is displayed as a checkbox on my forms and reports. I want to create another field that display the action "Send a cleaning poster to the ward" if the...

Please take 2 minutes to complete a quick online poll! http://www.misterpoll.com/polls/504429

I created a Pivot chart in Excel and when I have got the data from an Access Table, it shows my Yes/No fields as 0's and 1's. How would I get my Pivot data in Excel to show them as Yes and No's.

I work for Infection Control as an Analyst, our database is the nuts, and the develeoper knows her stuff. Email me if you need any help, simon.evans@hey.nhs.uk

Afternoon all, I am puzzle by probably a simple query. I currently have a queries that finds all matches by Surname and Date of Birth, ie I have a table of temporary unit numbers and a table with actual unit numbers, and daily this is run and it shows possible matches. How would I run the same...

Possibly a long term thing, but with regards to the database. I have observed for months now the ongoing problems and changes which constantly occur. The explanation I am given is that to transfer over to a server would be time consuming and may have many many unforeseen impacts. My suggestion...

=$V$67>=75 and $V$67<=84 The above formula keeps giving me an error message when in conditional formatting. Im trying to format it to show a value between 75 and 84

Morning, could anyone advise as the most cost effective way to gain a qualification that is relevant to MS Access. I am an IT Analyst and have the basics, and have developed some good databases, however my knowledge of Visual Basic is zero. I have had my personal development reveiw and have been...

How do I insert a Yes NO field in a form on word please

Huge problem and am baffled, All I need to do is show just 2 lines for a person to summarize, I dont need to know a person have multiple samples, I just need to know if a person has had samples using 2 ID's, as they will then need to merged! Example Table below Name PersonID...

OK another one: Table 1 has S (Forname), Evans (Surname) Table 2 has Simon (Forname, Evans (Surname) How do I run a query that shows me matches from both tables based on the first letter of the forname and the surname.

I have 2 tables of data from different sources, Table 1 - Surname,Forname,JobTitle - (ManuallyEnteredontoDB) Table 2 - FirstName,Middlename,Surname,JobTitle - (StaffList) My objectives are: Merge to 2 tables Find any duplications

Yep 12 sections eg Section 1 - Care Of Equipment Q1 Does the ward have a checklist Q2 Is the patient eqipment clean etc etc to Q15 All with Yes No NA answers, surely forms/reports/data access pages can generate exactly whats currently on Excel and produce the reports too that are needed...

Ill do my best We use Excel for Audits, these are taken off the intranet and via macros stored on your PC when 1st open, you then complete the audit stating Area/Dept/Date/Name/Occupation plus more headings, then there are 200 questions to enter all yes no answers! Then when the save button...

Question, we use an Excel sheet for Audits which have 200 questions on, I said it may be better to put on Access, cant remember the reason why something to do with formulas. Anyway, is there a way to auto enter into a database, because i had to sit and manually enter 100's of audits into a...

arrgghhhh, yesterday for some reason I couldnt get connectors on my word document for flow charts, and while at lunch my supervisor sorted it for me, however she is not at work now until Monday and I have to do a very complex flow chart, I've checked the customize and every location I can think...

As I start inoutting data, is there a way access can produce a drop down list from the value I enter eg I enter smith in record 1, jones in record 2, then when I enter record 3 smith and jones appears on a drop down in so on, ie an accumulative list!