Recent content by sislman01

Thanks guys that helped big time. regards matt

Hi, I'm new to this so please bear with me. I have a Table consisting of data thats been imported from CSV. Dates contained with in the data are in text format i.e 12122009 (English date format). I can convert these to dates unless the first digit is Zero. Access seems to not show the Zero...

Hi, Can anyone tell me if it is possible to Partition a table using unequal increments. The code I have used is Partition([Column A],0,1000,100) which sets increments of 100, however, I need to set increments of 3, 5, 10, 14, 31 etc and I cannot find anything that explains how I do this...

Thanks guys, I used this sql query to group the column by equal bands. SELECT Count(Bluetest.[Holiday Duration in Days]) AS [CountOfHoliday Duration in Days], Partition([Holiday Duration in Days],0,1000,50) AS Range FROM Bluetest GROUP BY Partition([Holiday Duration in Days],0,1000,50) If I...

Hi, I would like to know how i can group numbers into bands. e.g Col 1 1 2 3 4 5...

Hi, I have a database which contains the following column: - TYPE OF COVER This column has various covers in it i.e. 'COMP', 'TPFT', 'TP' etc I would like to be able to run a query that shows the following columns: - TYPE OF COVER , TOTAL NUMBER OF EACH COVER, PERCENTAGE TOTAL I am new to...

Thanks Len, How do I combined this in a WHERE query. I would like to say WHERE a date falls BETWEEN date (a) and date (b) then show the data. Also do I show dates as 01/01/2005 or 01012005? Regards

Hi, I need to look at data where a date falls between two dates. i.e. I might want to look at sales made between 01/01/2005 and 01/12/2005. Im new to Access and know that you can use BETWEEN but not sure how to write the query. Thanks

Thanks for the quick response:)

Hi, I hope you can help. I have an Access Table and need to write a query that extracts data where i.e. Date (a) is 30 days or more earlier than Date (b). Many thanks