Search results

They are indeed codes: eg C00.1, C00.2, C00.3, C00.4 D32.1, D32.2, D32.3, D32.4 These are diagnosis codes and are required in this output, however locally they are stored in their own table.

Hi guys, I've created a query which does the trick, however when I add this criteria into 12 different field I comes back with argument too long etc. I wondered if there was a why to reduce this in any way. To get round it Ive created 2 query and put them in a Union query which works but was...

How do I apply this function to a table eg called Table4

That formula works in Excel but need it in a query to be honest

Sample Data (received in a text file as text unfortunately) Dec 5 2014 12:02PM Dec 8 2014 3:36PM Dec 9 2014 11:55AM Dec 10 2014 12:03PM Dec 11 2014 4:06PM Dec 12 2014 11:41AM Dec 15 2014 3:38PM Dec 15 2014 10:34AM Dec 16 2014 3:38PM Dec 16 2014 11:03AM Dec 17 2014 3:39PM Dec 17 2014...

=TEXT(TRIM(MID($A2,5,2) &" "&LEFT($A2,3)&" "&MID($A2,8,10)&" "&RIGHT($A2,2))+0,"dd/mm/yyyy hh:mm:ss ") Is it possible to replicate the above formula from Excel into criteria in an Access Query. Assume the cell reference $A2 is a text field which has customised date info in it but is not a...

Sorry guys got it in the end, but thought I'd share my solution, there is probably and easier way. Our financial year is April to April so had to change it slightly to get the required results: FYear: Year([ReferalDate])-IIf([ReferalDate]<DateSerial(Year([ReferalDate]),4,1),1,0) & "/" &...

Hi guys again, I use the following criteria which returns the correct Fiscal Year (eg: 2015) FYear: Year([ReferalDate])-IIf([ReferalDate]<DateSerial(Year([ReferalDate]),6,1),1,0) What I'd like is for it to return 2015/2016 so I assuming somewhere in the above criteria I add a +1 also with...

Someone decided to be clever and send a text file with a stupid date format, they know they are being stupid but without pointing out the obvious and going back to ask them to send me the right date format, I wondered is it possible to show off a littl ehere and get a working date format from...

Hi guys I'm almost there but struggling a bit. I have 2 date fields which are text dates Field Name, Field Data, Outcome (What I want it to be) [DOB], 20090702, 02/07/2009 [StartDate], 20141127, 27/11/2014 I've managed to convert both into date formats using CVDate, but what Im looking for...

695515*97 531924*11 495853*131 377035*181 Is there a way to extract the 97, 11, 131, 181 numbers from the above list in a separate field?

The query itself is quite complex but in essence a whole range of criteria needs to be met to appear on this report. Our coding team update data routinely, and only when something is coded would the criteria needed to be met. So initially we may get 20 records but then as the coding gets done...

Hi Guys again, As some of you are more than helpful I thought I would ask the question here. I have currently taken on a procedure which I feel is very long winded and was hoping for some inspiration here to streamline it. Using just one table I have to run a query which has a date...

Hi guys, I know very little of code, but finding a few things out that are really my life easier. I have set up a macro which is very simple and just opens a number of queries. I dragged the macro to my desktop and then moved it to my StartUp menu on my PC. The result is when I turn my computer...

Ok those worked a treat and many many thanks for the support on here. LinkCheck: IIf([DateOfDevice]>=[AdmissionDate] And [DateOfDevice]<=[DischargeDate],"POSSIBLELINK","IGNORE") Based on the same query I now have 3 Date Fields all formatted and identical, however when I put in some criteria to...

DischargeDate: CDate(Format([disdate],"dd/mm/yyyy")) I use the above formula, but when the [disdate] is blank I get the #Error message, ideally I would like this to be blank if its possible??? Any thoughts Kind Regards

Hi again guys I have 2 table both with Date of Births, the field name in one is DOB and the other its DateOfBirth. How would a write an IIf Statement that would say If DOB is within 10 days either side of DateOfBirth then "Yes" else "No".

Is there anyway in Access to run query similar to the Duplicates, but searches an almost match, for example SMITH, SMIATH would be returned, and also JONES, JONESS would be returned. Its a data quality check on a Surname field where we can identify discrepancies better where the names almost...

[Query]="Null Forname/Surname" OK Ive done this and it doesnt work, obviously Im missing the boat here, my Field/Text box is a Forename Field, and I want it formatted when "Null Forname/Surname" is displayed in the Query field

Hi chaps, I would like a field on a form to be highlighted based on a value of another field. An example would be I would like my FORENAME field/text box highlighted in red when my UPDATENOW field displays YES.