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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by straybullet

  1. straybullet

    Convert Excel formula for Access and run in text box?

    I had good luck using Allen Browne's MaxOfList/MinOfList functions. (http://allenbrowne.com/func-09.html) Create 2 additional textboxes on your form (you can hide them later). I labeled mine txtMax and txtMin and refer to them in the calculation textbox. For your formula, it would be...
  2. straybullet

    Need help displaying desired records in subform

    Take a look at datasheet view for the subform. Let them hate - so long as they fear... Lucius Accius
  3. straybullet

    Looking for query to flip excel data over and over again.

    Thank you both - going to experiment with both of those suggestions this weekend. My apologies for the layout of the table in my original post, it looked just right in the preview. Let them hate - so long as they fear... Lucius Accius
  4. straybullet

    Looking for query to flip excel data over and over again.

    Been away awhile, working in finance now (not as much call for database design, until now!) I've been given survey responses in Excel in the following format: DataID recordid Q47_1 Q1 Q2 Q3 Q4 1 6347684356653 4356653 5 4 3 2 2 6347682756353 2756353 5 4 4 4 3 6347682233 2233 1 2 3 4 4...
  5. straybullet

    Ranking Query Woes

    Thank you both! PHV, I wasn't ignoring your initial posting of the fix, it must've gone through while I was getting my answer to dhookom together (in between dealing with work junk...) Let them hate - so long as they fear... Lucius Accius
  6. straybullet

    Ranking Query Woes

    You'd think that was the case, but it appears that the or(Dupe.SumOfCalcQuantity = qryGroupedQuantities.SumOfCalcQuantity and Dupe.id > qryGroupedQuantities.id) is doing it's job EXCEPT where it involves the top 2 records. ex: strmaterial strsoldtopartynum sumofcalcquantity HowMany...
  7. straybullet

    Ranking Query Woes

    Clinging to Access 2003... I have 2 versions of this 'sorta' working... SELECT qryGroupedQuantities.strMaterial, qryGroupedQuantities.strSoldToPartyNum, qryGroupedQuantities.strSoldToPartyName, qryGroupedQuantities.SumOfCalcQuantity, (SELECT Count(*) AS HowMany FROM qryGroupedQuantities AS...
  8. straybullet

    Pivot Table Connection String - How to hide it?

    What I do with several pivot table reports I send out daily is actually copy the area the PT is in and paste special values. The file size is much smaller but it can't be manipulated by the end user - useful in my case. Let them hate - so long as they fear... Lucius Accius
  9. straybullet

    How to hide results of the intermediate queries in MS Access

    Not sure if this is what you mean, but... If your main query refers to the 'subs' (ie: the subs are components of the query) they will run automatically when the 'master' is run. For example: SELECT qrySourceCost.strSourceCode, Sum(qrySourceCost.curIssueCost) AS YTDCost FROM qrySourceCost...
  10. straybullet

    populating numbers

    If 1 is in A1, check out Fill Series (Edit menu)... Let them hate - so long as they fear... Lucius Accius
  11. straybullet

    Comparison Operators

    True Skip - but we're not actually doing math with them... it's more a matter of setting criteria for a search. For instance, needing to find all the customer accounts within a certain numeric range. You know tharg, I actually sent a set of screenshots of query results using the different...
  12. straybullet

    Comparison Operators

    Thanks all! I tried explaining that Not <=100 would result in 101 and greater the same as >100 does. Falls on deaf ears. Skip - as expected tis chilly in the great state of Pennsyltucky. The air is crisp and the rut is on! The fun part in all this is that these 'options' magically appeared on...
  13. straybullet

    Comparison Operators

    Perhaps one (or more) of you can mediate here... There has been a debate raging around here regarding the use and meaning of comparison operators. For instance, there are some who say that using 'NOT <=' is not the same as using '>' (and that the inverse is also not true). There are those who...
  14. straybullet

    Can I save a doc without the working toolbars?

    While there may be a way to do what you're looking for in Word, I'd email them a pdf of the report. Let them hate - so long as they fear... Lucius Accius
  15. straybullet

    Excel Formula Help

    Well, once again, taking a shortcut doesn't pay off... Sorry, my goof! Incrementing from 5 to A08110006 works fine with the above but the following allows it to increment from A08110005 to A08110006. Also, combining the yymm portion shortens it a bit...
See more

Part and Inventory Search

Back
Top