Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dm5085

    Filter subform from another subform

    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.
  2. dm5085

    Filter subform from another subform

    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...
  3. dm5085

    Compare records and insert data

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

    Compare records and insert data

    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...
  5. dm5085

    Passing List box data to query

    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...
  6. dm5085

    Unconventional Grouping on Report

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

    Unconventional Grouping on Report

    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...
  8. dm5085

    Unconventional Grouping on Report

    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...
  9. dm5085

    Calculating Sum in query

    That did the trick. Thank you so much!
  10. dm5085

    Calculating Sum in query

    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...
  11. dm5085

    Calculating Sum in query

    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...
  12. dm5085

    Calculating Sum in query

    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...
  13. dm5085

    Calculating Sum in query

    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...
  14. dm5085

    Calculating Sum in query

    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...
  15. dm5085

    Calculating Sum in query

    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...
  16. dm5085

    IIF statement dropping records

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

    IIF statement dropping records

    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...

Part and Inventory Search

Back
Top