Recent content by simon4amiee

morning all, In just about to create a form in Access 2010. Its very simple and has around 10 fields. What I didn't want to do is base the form on the main table (eg I dont need to see the other records. All I need is a form to input my data, and then click a button to then insert into the...

Finally got this, was as simple of saving the Spec and using that in the macro, thanks for the support anyway

Thanks for all the comments everyone, some really helpful things to work with. The issue is that although initially a date/time field in the table. When I use the right click Export options to CSV, select Delimited, Comma separated and to include headers. The date/time field loses the zeros in...

Totally agree and understand, however unfortunately this is the format it must be in as the CSV get run through a Toolkit and having a valid date there makes it fall over, think the software is from 1066 or something. Either way Im trying Trim, Replace etc and struggling to find the right...

How do I strip the zeros from a Date field. My export to CSV shows the date as 01/01/2015, I need it to show 1/1/2015 Any ideas

Hi guys, The code below bring back the results I want however..... SELECT dbo_MF_PATIENT.Forename, dbo_MF_PATIENT.Surname, dbo_MF_PATIENT.DOB, dbo_MF_PATIENT.Postcode, Count(dbo_MF_PATIENT.HEYNo) AS CountOfHEYNo FROM dbo_MF_PATIENT GROUP BY dbo_MF_PATIENT.Forename, dbo_MF_PATIENT.Surname...

Hi all, Im stumped now, early on in my code which worked for years, now suddenly does not and displays the error -2147217904 - Too few parameters. Expected 2 I can't seem to get to the bottom of it, is there a way I can find the problem out 1 line at a time or is it obvious from here...

Struggling, InStr: InStr([Player Name],",")+2 This retuns the number of the letter Im after ever time, but just to display it as letter, the rest I can do I think.

Hi guys, is it possible to extract the first letter of a surname in an Access Query? Below is my sample data, and below that is what I want to acheive. Player Name Hart, Joe Cech, Petr de Gea, David Szczesny, Wojciech Mignolet, Simon Reina, Pepe Lloris, Hugo Howard, Tim Begovic, Asmir What I...

Hi all, I have 3 fields: CustomerID (Alpanumeric) AttendDate (General Date) Area (Alphanumeric) Is is possible in a query to pull back 100 random CustomerID's on a set AttendDate. For example I have 1000's of Customers who attend each day, I want to do some Data Quality on 100 Random...

Hi guys, I've a nice formula which work the majority of the time, the only time this doesn't work is Bank Holidays. Is there a way to build on this: >=Date()-IIf(Weekday(Date(),2)<2,4,2) And <=Date()-1 The above simply runs a report for the last working day, expect if today is a Monday then it...

Hi guys, should be doable, I have a very simple query which brings back a count of records. I would like to add a percentage column to this which shows a percentage by ClinicCode. I've attached some sample data and what the inteded outcome should be. Any help would be appreciated.

Hi guys, I cant seems to nail this one. I've two fields to work with: [Date of Device] [DischDate] If i was explaining it, it would be as follows: If [DischDate] Is in the next month after [Date of Device] then Y else N. to add for example if the [Date of Device] is April 2015, and the...

Hi guys, I was given this to use but its not working in Access and my SQL knowledge is just at the start of my journey im afraid. SELECT systemno, COUNT(DISTINCT postcode) AS Total FROM dbo.InterData WHERE disdate >='20150301' And disdate <='20150331' GROUP BY systemno HAVING...

LOCALID - POSTCODE - GPCODE PTO1395164 - DN34 1AB - G9999981 PTO1395164 - DN34 1AB - G9999981 PTO1395164 - DN34 1AB - G8909058 PTO1395164 - DN34 1AB - G8909058 PTO1395164 - DN34 1AB - G8909058 PTO1395164 - DN34 1AB - G8909058 PTO1395164 - DN34 1AB -...