Recent content by Meso

Leslie, That was it, I really do appreciate the quick response. Thanks...Bart

It seems I am missing something obvious in making this simple query work. I have a query that is going to take the whole number ratings given to a person based on their performance on a series of tests and then return the percentage of total possible points they accumulated. I have a second...

Yes it can be done. On the Query Manager (8.3) in the Fields Tab, if you click on the Edit button you'll get access to to various options such as renaming the field label for output, etc. One of the options are settings for several aggregates, SUM, MIN, MAX, AVERAGE and COUNT. Your...

Are you using Peoplesoft's Query Manager web interface to create your query? If yes, there's a little trick to getting the outer joins to work.... If your using Query Manager to write the query, doing the outer joins involves using an expression to create the join. Peoplesoft Query Manager...

Thanks Jeremy, I really appreciate the response. I'll have to try this out as I didn't think of this approach. There are actually various suspense days based on each step of the grievance process, but I think this should work fine with the calender days. Attm, we just manually enter the...

Hello, I have what I think should be a simple problem to solve, just need to have some guidance on VBA. Since I have little working knowledge of VBA, I'm guessing on the Select Case usage. I'm working on a small database to track grievances filed by various employee unions. There are several...