Search results

Thanks Galaxiom. But in my version of IE there is no "Copy shortcut". There's "Copy" but it's greyed out. Don't know why! However, I did find that by clicking "View source" I could find the link, as shown in attached picture. Kinda finicky, but I guess it'll do!

I have two browsers installed, IE8 and Chrome (Version 35.0.1916.153 m) I need IE8 because it links to clinical systems in the hospital where I work and those are apparently not compatible with newer versions. But I am also part of a research network which is using Google Apps, so I have...

Does your output actually function as a time, or is it just text that LOOKS like a time? If it's really a time (CDATE makes me think it is) you could try: Right-click the query column > select Properties > Format > "medium time".

StudySummary and Recruitment are both raw data files that I receive. They are supplied by a national "head office" (kind of) to various regional clinical research networks which all have different systems, some as basic as Excel pivot tables. So I suppose they have to cater to the lowest...

Hi, I get two weekly files 'StudySummary' and 'Recruitment'. 'StudySummary' contains a list of clinical studies, 'Recruitment' contains the organisations in our area with the dates they have recruited patients to those studies. (It’s all anonymised and in the public domain) I’ve attached a...

The best one I've heard recently: A roman catholic priest and a protestant go the the races. An owner approaches the priest and asks him to bless his horse before the race. The priest does the whole latin thing, “In nomine Patris…” and the owner makes a generous donation “ahem...to the...

Colin....In what sense are they "British" jobs? You mean vacancies that happen to arise in Britain should be reserved for British people? Would you define British people as holders of a British passport? Or those born in Britain? Or some other mechanism?

Thanks for your suggestion JHB. I did get it to work - eventually!!! - but there's still something I don't understand. I noticed in your picture that while you are formatting the chart, you can see the columns as they will appear in report view and your data table also displays the ACTUAL...

Hi, When you create a column chart and then change one of the series to a line, how can you then apply formatting to that line? I've attached a stripped down database showing what I'm trying to do. Series 1 shows individual monthly values (percentages) and series 2 shows the target which is...

Well that's a real shame Bob, but you know when the time comes! You've replied to many of my questions over the years and moreover I see your name cropping up again and again with helpful advice, when I search the forum for answers to whatever problem I'm currently having. You'll be missed...

Hi Lilly, It's a pleasure! I have learned almost everything I know about Access (which still isn't a lot!!) from this forum. So occasionally I find a question that is is not above my skill level and it feels good to help. Now as to why your query worked with Yes and not with "Yes", well I...

You need another IIF. You can nest IIFs either by replacing an existing element with another IIF, or by wrapping another IIF round the outside. The crucial thing is that the syntax of each IIF must be preserved i.e. IIF(condition,true_part,false_part) It's easy to overlook a bracket or comma...

Just use ... Between [Start Date] And [End Date] Or Is Null ...in your criteria. I think that should do it. For the 2nd part you need an IIF function and I assume you need that same "Wrapper" thing in both parts: IIF([CO_resp_recd] is NOT Null,Wrapper([Review...

OK, I see what you mean now. I had to mock this up in the attached database and - initially - I got exactly the same as you. And you're right about the reason. I wasn't able to do anything in the report, but I added a separate query (see query 3) which summed the outstanding amounts for each...

If you ALWAYS want to get the last day of the previous month, then you can use DateSerial(Year(Date()),Month(Date()),0) As of today, 3rd March, that function returns 28th Feb. If you want to calculate the last date of the month previous to some other date, then you would replace Date() with...

Hi, So ASSESS is the invoice amount, is that right? And you have a separate field called PAYMENT? The layout below is how I would do it. You'll need to substitute your own field names, but the important thing is to sum the payments in the right footer and then subtract that from the sum of...

I've never found a way of doing this. But does it HAVE to be Word? Is the idea that you want to email the report, or save it to a folder as a snapshot? Something like that? You can install CutePDF (or something similar) free of charge and it allows you to "print" your report to a PDF file...

If I have understood your requirement correctly, then the attached example should do it. You type something in the box, hit Search and it find records where the data matches any of the fields shown. Try entering "Jack" for example and you'll get results in the [Last name], [Forename]...

I assume your search button runs a query? Or perhaps displays a form or subform based on a query? If so, then you need to put something like [Forms]![NameOfSearchForm]![NameofSearchTextBox] on the criteria line in each column of the query, but also on SEPARATE lines, working diagonally down...

Not disputing any of that and am happy to let bygones be bygones as far as the royals are concerned. I just wish they would be gone!