Search results

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

Hay everyone Just wanted to ask if anyone has suggestions for a check printing program. At work I am going to get an export file from a SQL Server database and it into another table use Access97 front end to print checks. If anyone has already been through this I would appreciate any insite...

I using the following code from this forum Private Sub Text0_KeyDown(KeyCode As Integer, Shift As Integer) Dim stFront As String Dim stBack As String Dim lPos As Long If KeyCode = 9 and Shift = 0 Then KeyCode = 0 lPos = Text0.SelStart stFront = Left(Text0.Text, lPos) stBack = Mid(Text0.Text...

Ok I got it figured out. I found out you can't just sum the field you have to sum the recalculation of the field.... Thanks kim

I am using A97 I have several fields on the detail part of a report like: QNum A1 CorrA1 QWeight txtDecision Qnum is the question number A1 is the users answer to question CorrA1 is the correct answer QWeight is the Weight of the Answer sumofquestionweight txtDecision is a calculated field...

I appologize in advance for this confusing question. I have a table that list parentID,Desc,ChildID,Desc Here is my problem... The hiarchy of the system I extracted from is you have a group (parentid)which is a "parent" to a subscriber (the childid). The subscriber(parentId) which is a...