Search results for query: *

Many thanks all Steve

Thanks all for your advice I used the SQL provided and thats doing more or less what I needed and can carry on from there. Many thanks for the help - I thought there had to be a way somehow without using crosstab. I'm using several pieces of software which does complicate things a bit. The...

Hi Thanks for your reply. These are not multiple tables but one table and yes its imported data from an excel spreadsheet. I can see how the way I explained it above that you may think its mutliple tables but no. Its one table to which I append the stats to each month. I need to get the info...

Hi can someone help me with a crosstab problem? It may be it can be acheived without a crosstab but with some clever SQL instead but I cant seem to work it out I have a group of people who are producing stats each month,so for the month of January I have a table (tblstats) with something along...

Hi Works a treat - thanks for your all your help. steve

Hi One last question and I promise I'll leave you alone I've gone thorugh your code which works fine for the month of March and from your construct I have been able to see how it works by changing the syntax from -4 to -6 to get January, -5 to get february etc. I'm going to be adding new...

Hi PHV That looks the business thanks very much for your time Hi r937 Thanks for your help. I appreciate the fact that I hadnt given you the date field - I realised that as soon as I saw your code and thought I needed to substitute in what the actual field was called. All I was saying was...

Hi PHV - This appears to be working but I need to limit what Histology records it looks at. In my table are patient results going back a few years and whilst I need them to be in the table, the actual ones I'm interested in have only been reported in the last month or so So can I do this...

Thanks PHV That does indeed work as well. When you see it written out like that (and the other two options) it all seems straight forward. Obviously have a lot more reading to do regards steve

Hi Sorry to trouble you again Now that that is working I would like to add another level of complexity. The Histology results are reported on a certain date and I need to correlate those with the cytology as above but only cytology results which are no more than 6 months previous. So if the...

My sincere apologies - I tried both of these examples again this time double checking that the table its perfroming the query did in deed have data that matches the criteria - always I helps I find. Anyway both worked many many thanks regards steve

Hi Both of these options gave me no error messages but also no results. I had the fields NHI, Surname, ID [Final Diag] but there were no records when I know there should have been. Any ideas? many thanks for your assistance on this Steve

Hi I've only just started to use and learn SQL and think its a great and powerful language. Unfortunately I'm trying to bite off a bit more than I can chew but its something I need to do. I'm trying to run this query in access but I keep getting an error message and cant see why. The message...