Recent content by CoolDude2000

Thanks very much ByteMyzer. Worked perfectly.

Thanks alot ByteMyzer. I will try tomorrow.

<Done>Do a self join on FName. This will give you one record for every combination of FDate pairs for each FName. Use DateDiff to get the number of months between dates pairs.<Done> Compare this to the number of records between the two months. Where the count of records is the same as the...

I tried this query below but it is running long in Access database not retrieving any results. SELECT T1.fName, COUNT(T1.fDate) AS CountOffDate FROM (SELECT DISTINCT T.fName, T.fDate-Day(T.fDate)+1 AS fDate FROM MyTable T) AS T1 WHERE T1.fDate>= (SELECT MAX(T2.fDate) FROM...

Results should be: Fname Total Consecutive Count John doe 4 Test 2 Fname Fdate john doe 10/1/2008 john doe 9/1/2008 john doe 8/1/2008 john doe 7/1/2008 john doe 5/1/2008 john doe 4/1/2008 john doe 3/1/2008 Test 4/1/2008 Test...

Please look at the example table below. I need to get the total counts of the consecutive months for each Fname. Please help. Results should be: Fname Total Consecutive Count John doe 4 Test 2 Fname Fdate john doe 10/1/2008 john doe 9/1/2008 john doe 8/1/2008 john doe 7/1/2008 john doe 5/1/2008...

I know it is 7 yr old posting but the solution provided did not work. Can you help?

Hi, When I am running this query below...access running longer without any retrieving results? I ran this query in SQL Server Management studio but getting error msg below: Msg 206, Level 16, State 2, Line 1 Operand type clash: date is incompatible with int Please help. SELECT...