Recent content by Blkblts

I need this exact same thing. Did anyone find an answer? Thanks Kim

Importing Multiple spreadsheet WOW This post was very beneficial. Thanks a bunch

Rich, My query that is behind the report is a union query of all my queries. By using the multiselct box then when they clicked a question I would build the SQL of Select * from Q1_TTL Union Select * from Q2_TTL Union Select * from Q5_TTL Union And so on until they were finished with their...

I agree 60 queries is alot. All I receive is an .xls file that has 20 Answers for a user in a single row. The columns are the Questions. Some of the answers are favorable. Such as Is you doctor nice. Yes would be more favorable then NO. So I can only put a total of who said YES in the...

I am using Access 2002. I have created queries in hopefully the normalized form. tblSurvey, tblQuestion, tblAnswers, tblResponseoptions. I have also created reports. Now I have been told the user wants to pick and choose which question go on the report. Gee Wiz.. Can anyone point me in the...

This helped me alot. I needed to browse for a file name. Thanks so much for the post.

Thank you G.. This was very helpful. I analyzed the data and some of the reference years would need to be tweeked, because there is a date in 2005 and it gave the reference year of 2007, but all in all you have given me alot more to work with. Tomorrow I will spend some time with your query...

Thanks for your reply.... I hope this explaination helps... Well what I am really looking for is to place monthly premium into the proper year for a contract. The contract may span multiple years, but will not be longer then 12 months. I need to figure out the number of months the contract...

Hello I am using Access 2002 on a WinXp PC. I have the following in a query. Count_E_Months: IIf([CEYear]=Format(Date(),"yyyy"),DateDiff("m",[Contract Effective Date],DateAdd("m",1,"1 " & Format$(Date(),"mmmm yyyy"))),0) Count_R_Months...

Thank you yes that gets me further on my calculations. I appreciate your reply. I will trudge on with rest. K

I appologize if this has been posted before I have been searching all afternoon off and on and have not found anything yet. Using Access 2002 SP3 on an Windows XP :eek: . I have a table that contains the following name effective date renewal date monthly premium I need to calculate the...

Did you figure this out? Did you ever find an answer for this? I have the same issue kim

Wow how awsome it that? I am searching today for a browse resolution too. Someone posted just two days ago for same thing. I got my answer without having to post. Thanks so much

Another Alternative I had this same issue with a little twist. I thought I would go ahead and post for future reference to someone else. This site is so helpful to me I hardly ever get to actually contribute. I have a tblRankTest. I created the following: qryCountproduct SELECT...

Thanks