Search results for query: *

Well I have looked in Northwind Sample and at so many threads here about this but it's not exactly clear (to me anyway) how to do this in code and I was hoping maybe someone would be able to help me with a more personalized solution. I've been trying everything I can think of for hours.

I have a problem on one of my forms that I think probably has a very easy solution. I have two continuous form subforms on my mainform. I've added a button to the subform named frmSubHypoJobMatches called cmdViewMatches. I'd like for this button to filter the records in the second subform...

Golom, Thanks so much! The second part was pretty simple once I had the first part. I appreciate you taking the time to answer!

Hi All, I don't do things this odd very often so I need someone to point me in the right direction. I have a table name STGDEPTTREE with data as follows Deptid Tree Effdt BU 0000A 12/1/2005 ALL 0000A 1/1/2006 ALL 0000A 2/1/2006 ALL 0000A 3/1/2006 ALL 0000A 4/1/2006 ALL 0000A 5/1/2006 ALL 0000A...

I have a form that has a multi-select list box. I've succeeded passing the string value to a query but my query won't pull any records I suspect because I can't figure out how to delete the last "OR" from the string. Here's my sub: Private Sub lstStatus_AfterUpdate() Dim AwardStatus As...

Brilliant! Worked like a charm. Thank you so much.

Dhookum, thanks for the reply. What I can't get my head around is how to add the detail record for the NLM in the detail section, I can create the footer. Here are the query results: NLMName MgrNam Award1 Award2 Award3 Award4 JONES, SCOTT MILLER, JOE 4 0 0 0 JONES, SCOTT SMITH, BOB...

I have a report that is pretty basic, there are award types and counts by Manager in the detail section and a subtotal of these counts by Next Level Manager in a footer called NLM. I've been asked to add the awards given by the NLM in the detail section and have a grand total of all in the...

That did the trick. Thank you so much!

Yes it does help a lot! I just realized that I'm going to need to group by quarter and recognition year and MgrName also. I've tried adding them to the sql but it doesn't seem to like that very much. Here's my sql SELECT Sum(IIf(NominationType=1,1,0)) AS OTSEMPREC...

That works perfectly except now I have to count 3 other nomination types and I'd like to do it in the same query if I can. I'd like the results to look something like this: OTSEMPREC SENEMPREC SEAEMPREC GOLDCOINEMPREC 4 2 1 14 Ive tried...

My data was wrong, sorry Try this NomineeName NomineePosID NominationType NominationId CARLSON, PETER M 417464 1 27210 CARLSON, PETER M 417464 1 27210 PETERSON, JOHN C 269702 1 3373 PETERSON, JOHN C 269702 1 3388 FOSTER, ALTA M 58036 1 13165 MICKEY MOUSE 269702 2 334488 DONALD DUCK...

Sure thing. NomineeName NomineePosID NominationType NominationId CARLSON, PETER M 417464 1 27210 CARLSON, PETER M 417464 2 27210 PETERSON, JOHN C 269702 1 3373 PETERSON, JOHN C 269702 2 3388 FOSTER, ALTA M 58036 2 13165 So in my query results, I'd like to see [OTSEmpRec]= 4...

Thanks to both of you for your replies but what I need to is count Unique nomination ID's where the nomination type is 1. The data is structured so that employees can receive many of these nominations in the same quarter but we only want to count them once in this new field [OTSEmpRec]. Any...

I'm trying to calculate a sum of Unique ID's in a query. OTSEmpRec: IIf([tblNomination]![NominationType]=1,Count([tblNomination]![NominationId])) It's not allowing the query to run with the error message "you tried to execute a query that does not include the specified expression "". Can...

That was exactly what I was trying to calculate. Thank you!

Can anyone help me with the following: I have an expression in a query that returns a null value if the month is 12 and the day is 1. Expression works properly on all other dates. Can anyone figure out what's wrong with my syntax? All I'm trying to do is add 1 to the recognition year if the...