Search results for query: *

Funny thing was, when I read your response, I was like...DUH. Thanks for the help.

I think my answer is to use multiple queries or a report, but figured I'd ask the experts before giving up on the single-query idea. I have a table that has 11 fields in it. Field1 is used for grouping. Fields 2-11 are called "Level 1", "Level 2", "Level 3", etc. What I am trying to do is...

Ok, I see what I missed. Thanks, that did the trick in getting rid of the query and works. My last posted code with the sqlstr from PHV's first post is what did the trick.

Function Reminder() Dim X As Boolean Dim mydb As DAO.Database Dim rst As DAO.Recordset Dim rst1 As DAO.Recordset Dim sqlstr As String Dim sqlstr2 As String Dim writelog As String Dim sbj As String Dim bod As String Dim list As String 'Define...

Thanks for the help thusfar. I'm now getting an error at a different point. Here is what I have: Function Reminder() Dim X As Boolean Dim mydb As DAO.Database Dim rst As DAO.Recordset Dim rst1 As DAO.Recordset Dim sqlstr As String Dim sqlstr2 As String Dim...

Okay, a while back I was able to use code to send automated emails. This code works wonderfully for what we are doing. Unfortunately, we've expanded our needs and now I need a more complex email. What I am trying to do: sqlstr2 generates a list of each person that we need to send an email...

Thanks. This left me a couple of errors, but I was able to fix them. Needed to add "Do" to the front of the While line and had to change qry to an actual query in the database.

What I am trying to accomplish is creating XLS files based on the field [Reporting Level3]. All records will have a value in this field (something like "Doe,John Q.") and there are a total possibility of roughly 10. I want 10 files with each file including only those records. I really don't...

I tried your suggestions, but either don't understand coding enough or was missing something. I then decided to look at another database I have that does exactly the same thing and works to figure out where the difference was (duh, could have saved yesterday's headache). In my new database...

I know I am missing something simple here, but I can't seem to put my finger on it. I have a form with a combobox. When a user selects from the list in the combobox, it should refresh the subform data to limit the results to the selection from the combobox. If I hit <shift>-F9, the subform...

Oh, forgot to mention....in the X=SendEmail code, the third field is for attachments. Use the full path.

We use Lotus Notes and to-date, I was unable to send via Lotus Notes using automation. What I have done to automate the mail process is use the following code: Function SendEmail(strTo, strMessage, strAttach, strSubject, strBCC) Dim objemail As Object Set objemail =...

Okay, so this worked great to get the pre-tests scores. When I added the same code to get the post-tests scores, replacing the word 'pre' with 'post' post-QsRight: Sum(IIf([tblPerfManageTest].[TestType]='post',1,0)) The math suddenly got wrong. I started having both numbers added together in...

Thanks. IIf statements get me every time.

SELECT tblPerfManageTest.Name, Count(tblAnswerKey.QID) AS QsRight, Sum(IIf([tblPerfManageTest].[TestType]='pre',[QsRight],0)) AS [pre-QsRight] FROM qryNumQs INNER JOIN ((tblAnswerKey INNER JOIN qryPerfManageTestConverter ON (tblAnswerKey.QID = qryPerfManageTestConverter.QID) AND...

When I incorporate this, I got the following error: Subqueries cannot be used in the expression (IIf([tblPMTest].[TestType]='pre',[QsRight],0)).

I have a query that has the following fields: Name TestType Count(tblAnswerKey.QID) AS QsRight Is it possible to create two new fields, within this query, that are the contents of the 'QsRight' field based on TestType (there are only two test types). In otherwords, I want pre-QsRight and...

Stupid question #1 to add to this: When you enter in your strSQL line, how do you type in more text than one line allows? When I hit enter, it puts an end-quote on the line. I am still working on this, but the first problem I ran into was that. :)

I haven't a clue how to do this, if it is even possible. I have an existing query that generates a large report. This report then gets split into smaller files based on the field [Reporting Level3]. If it is possible, how would one go about creating the various .XLS files based on the results...

Thank you for the help. I understand the logic in why to do this and how to do it. I also understand the flaw in my original thinking. To answer some questions I saw, the feed I get comes from an external web page. The number of questions shouldn't change, but that was why I had the field...