Search results

I got a response from another forum in case anyone is interested: =INDIRECT(ADDRESS(ROW(),MIN(IF(D2:J2=Sheet2!$A$1:$A$10,COLUMN(D2:J2),"")))) Thanks

Hi I've done searches on this and am guessing I probably need Index and Match but have gotten completely confused with the answers that are there and can't see if any of them apply to my query. I have a sheet with Primary Diagnosis, First Secondary Diagnosis, Second Secondary Diagnosis, up...

Thank you. I've worked around it with attaching as a parent a rectangle to each tablix and forcing a page break after each which appears to be working.

Hi Does anyone know anything about Report Builder please - I'm using version 2.0. I did a search but couldn't find anything, so before I go writing my problem, thought I'd better check to see if anyone might be able to help!!? My problem is related to forcing page breaks when there is no data...

Hi Ray What I'm trying to do is put a calculation using the current date. Basically I have a Date of Birth field and an age field. Rather than fill out the age field, I would rather it do: (Today()-DateOfBirth)/365.25 (like you would do in Excel, or a DateDiff in Access), to give the age. I've...

Hi Agnieszka Thanks for responding! I'm on Word 2003. You can insert a field for date with 2003, but I'm not sure if this can be incorporated into the Form fields. The form fields now has an option for Current Date, but trying to use Date() in a calculation, still doesn't work. I'll keep trying!

Hi In searching for some help on date in Forms in Word again I came across this old post and realised that I'd never responded to the last post - I am sorry, I realise how rude this may appear. I can't remember what I did in the end. I also realise that you may no longer be on here, but just...

Hi both Brian and the Net! Thank you very much. The If's definitely work, and I'm going to have a play with the VBA in Excel soon! Everything's (almost) so much simpler in Access!! :D

Hi I’m trying to do a convoluted IF AND OR statement and am getting in a bit of a mess. I’m trying to say: IF A cell = “Achieved” AND B cell = “Y” OR B cell = “N” OR B cell = “Not indicated” Then value = “Achieved” IF A cell = “Achieved” AND B cell = “Indicated?” OR B cell = “Invalid...

Hi I am using MS Query to return data into Excel. I know Access but am quite new to MS Query and keep finding vast differences between the two!! I've looked on the help but it doesn't seem to be of any! I have two date fields which are formatted as dd/mm/yyyy hh:mm - and I need to take one...

Thank you! Why did I not think of that before!!!? That's great. :D

Thanks so much Brian. That was exactly what I was after but just couldn't manage it! Thanks for you help - both of you! :D

Fantastic - thank you! I wonder why the help says that SUMPRODUCT treats text values as zero though?! Thanks for your help! Ally :D

Apparently, SUMPRODUCT treats non-numeric entries as zero, where the entries I need it to count are text. Also I couldn't see any way of entering criteria. Back to square 1.

I was just thinking about trying that when you replied. I'll do it now. Perhaps the array doesn't work because it's in the one column???

Thank you but I've been on OzGrid all morning - been using a few of their examples but not understanding why it's not working. I've kind of found a way around it - non-array style - But am not sure if this is the most efficient way of doing it!? Tnx Ally

Hi I have a column in Excel where I would like to sum up those with the values of "No Scan Date" and "No Arrival Date". The column would look like this (but a lot longer)!: Time from Arrival to Scan (minutes) 170 266 No Scan Date 15 1213 No Scan Date 945 1135 32 55 No Arrival Date 731 No...

I believe I know what it is now! I have to include Is Null otherwise, it's excluding all the records that are null in that field. Bit weird as I've only told it not to include one particular thing but at least I know what it is! Cheers Ally

Hi David Thank you for replying. Yes, that was what I meant by taking out the <> - and it does just return the few that we expected.

Hi All Not been around for a while but I'm back!! I'm using MS Query as an external data source for an Excel spreadsheet. On inputting <> 'Inter Hospital Transfer' as criteria under a certain field in MS Query, I thought I would be asking it to exclude Inter Hospital Transfer from the...