Recent content by marcoman44

In a query I am trying to excldue the string "02710000" The problem is that it also excludes all nulls. I am using <> "02710000". Any help is greatly appreciated. Thanks Code: SELECT repFinancialInsured1.RxNo, repFinancialInsured1.DxDate, repFinancialInsured1.NDC...

Solution: http://support.microsoft.com/?kbid=822852

I had to do a restore from veritas. I then restarted (maybe prematurely) and I am now unable to get SQL Server to start. I think I wiped out all of the default DBs. Any help is appreciated.

I am in a situation were external factors are forcing me to change the Primary Key of my main table. The ID (Member_ID) is now only used for a segment of the business. The Member_ID field is the Foreign Key in multiple tables. The goal is to make Member_ID an int(autonumber). I already...

Thanks for the advise. I will use this in my next post.

I used the DATEPART command to give me a month number. Then selected Customer ID distinctly with month number. Then counted Customer ID to give total months. Thanks

I have tried every suggestion given. I do appreciate the help thanks.

What I think might work is to create a month field and update a month name based on Date. Then create a Distinct Customer ID/Month Then Count Month field and group by Customer ID. I will then export to Excel and Total and divide by number of unique customers. This is probabaly a major...

In my last post I thought I gave an accurate description of what I am looking for. I am not a programmer or DB guru nor have I ever claimed. I am just looking for some help and this is the first time on this site where I was denied.

Number CustomerID 0.102803738317757 AM101048425 Skip, This is the result (Top). I want the Number just to be an addition of how many months they had service. Example Number Customer 3 Customer 1 9 Customer 2...

Ok here in the Data: I have a customer ID and a corresponing Date of Service. The Customer could have multiple Dates withing the same month. I am only looking to see of the total customer base what is the average monthly enrollment per year. Cusomter ID DOS(Date of Service) 1...

SkipVought, I need to be able to figure out how long (Average number of months) that a customer is using this service. If they have an instance in the month then it counts for the month. I am not sure if the code solves this. Thanks,

Each row is consider one unit. I am looking to figure out the average monthly time that a user has a instance in a month over a year.

20031124 The above is stored as text in an Access DB. How do I convert to a Date/Time type. Thanks in advance for any help.

I have a list of customers that are on a program. In that program they recieve items that are dated. How can I figure out the average time a customer is on the program by this date. I am looking for a month time frame. Help is appreciated. Thanks,