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

    Convert Excel formula for Access and run in text box?

    ...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 =(([txtMax]-[txtMin])/([txtMax]+[txtMin]))*100 Let them hate - so long as they fear... Lucius Accius
  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

    ...qryGroupedQuantities.strSoldToPartyNum, qryGroupedQuantities.strSoldToPartyName, qryGroupedQuantities.SumOfCalcQuantity, (SELECT Count(*) AS HowMany FROM qryGroupedQuantities AS Dupe WHERE Dupe.strMaterial = qryGroupedQuantities.strMaterial and (Dupe.SumOfCalcQuantity >...
  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

    ...And eomonth([Forms]![frmExec]![subDynamic].[Form]![txtDate2])) AND ((qrySourceCost.strSourceCode) Not Like "ref" & "*")) GROUP BY qrySourceCost.strSourceCode; qrySourceCost (the runs automatically, providing the needed values to this query (and the report it's associated with) - never being...
  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...
  16. straybullet

    Excel Formula Help

    ="A"&TEXT(NOW(),"yy")&TEXT(NOW(),"mm")&TEXT(A1+1,"0000") would get what you're looking for. In the above, A1=5 and the result is A08110006 Not sure about the verification though - I'd think you'd need to use some VBA for that. Let them hate - so long as they fear... Lucius Accius
  17. straybullet

    Autonumering in subform

    Check out thread http://tek-tips.com/viewthread.cfm?qid=1509604 I'm sure you could adapt the provided vba to accomplish what you're looking for. Let them hate - so long as they fear... Lucius Accius
  18. straybullet

    Multiple Users in Access

    Hi pcolvin, One other thing to check (once you've implemented the above) is that all your users have full permissions (including edit) to the server folder where the BE resides. Let them hate - so long as they fear... Lucius Accius
  19. straybullet

    Trying to auto fill in field based on multiple fields

    Perhaps something along the lines of the following in your source query (you could also set it as the control source of a textbox on your label report with a leading '='): Trim([Salutation] & " " & [FirstName] & " " & [MI] & " " & [LastName] & " " & [Suffix]) &" ," Let them hate - so long as...
  20. straybullet

    Another Top by Group query question...

    please disregard... I had pasted the wrong version above and tried to 'edit' by using the back button, but it just made another post. Let them hate - so long as they fear... Lucius Accius

Part and Inventory Search

Back
Top