Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

="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

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

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

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

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