Search results

Thank you - just curious though, shouldn't we check to see what the frequency of the class is first? Some are annual, some are bi-annual, some are monthly, and some are one time. Don't we need to tell the query how far back to look, based on the frequency requirement?

That seems to have worked! Here's an additional level of complexity for you: Each of my classes has a required frequency. For example, Class1 is required annually, but Class2 is only required to be taken one time. Can we adapt this query to check for the frequency requirement of the class...

Hello experts, I am attempting to write a query that will allow a user to select a particular class from a dropdown list and check to see who HAS NOT attended the class. I have two tables, tblEmployees and tblAttendance. The linked field is EmpNo. Below is what I have come up so far but I...

Thanks for your quick response! I made a few adjustments to my query and got the results I was going for :) Below is what I went with, for those future supplicants like myself who may review this thread. Many thanks! SELECT OvertimeWorked.[Employee Number] FROM OvertimeWorked WHERE...

Hello Experts! I am attempting to count the number of distinct employee ID values in my query results, with little luck. Trying to design a pop-up window that shows the total. Below is my code. It's counting the values, but not correctly - it's not eliminating duplicates. The SQL behind my...

Thank you kindly for your response. I am now getting an "object could not be found" error at the "set myInbox" line. I'm thinking it can't find the folder being referred to :(

I have used F8 to walk through the code. The recipient.resolve seems to be working fine; it is at the Set myitems portion that it throws the error. If I do not add the step where the code searches for the subfolder (just leave it as the default inbox) the code works fine.

Experts, I have Googled this to no avail and come hoping you can point me in the right direction. Below is the code I am using to search for a particular email in an Inbox sub-folder of an email address. This sub-folder is renamed each day with the current date. This process can't be...

As is often the case, the simplest solution eluded me. Thank you for your kind response! This solved my problem with ease. :)

Experts, I am attempting to populate an "EmpName" field in my datasheet view subform based on the code below. What is happening is that the fields are ALL changing to match the employee number of the most recently added row (see attached image). Is there a way around this? Your assistance is...

I was able to figure this out - your solution of adding the SortOrder field to my query along with moving the "sort by" ABOVE the grouping level on my report did the trick. Thanks :)

Beg your pardon, when I change to EXPRESSION instead of GROUP BY I no longer get the error message; however, the sorting is still not working :(

Thank you, but neither of these solutions worked. I get the following error message: "Cannot have an aggregate function in GROUP BY clause"

Hi Experts, I have a report based on the below query. This pulls my records just fine into a report. SELECT Avg(tblScoring.NScore) AS AvgOfNScore, Avg(tblScoring.MScore) AS AvgOfMScore, Avg(tblScoring.IScore) AS AvgOfIScore, tblScoring.Nominee, tblScoring.AwardType, tblScoring.AwardYear FROM...

I was not able to find a satisfactory solution, so I wound up just squishing up all my report fields so that they appear on one page. This was a non-elegant but functional solution. Best of luck to anyone in the future Googling this issue, hope you are able to find a way to accomplish this...

The same thing. The report is longer, yes, but I still need to scroll down to view all the data, and this is what I have to avoid if the user is to be able to click a button to screen print the report and paste it into an email body.

Testing some more, I found that if I put the Move Size event On_Load it is actually making the report longer, but not the dialog window the report is appearing in. That's really what I need to have larger, so that the screen shot captures all data. Any ideas how this can be accomplished?

Sorry, missed that question. This code is in the On Open event. Thanks :)

Thank you so much, but this still is not working. The report opens, data appears in my text fields, but the rest of the information is missing. Any other ideas?

Thank you so kindly, but this doesn't seem to have made any difference. To help illustrate what's happening, I've included two screen shots, one with the MoveSize code and one without. This may help you see what's missing when the report renders :)