Replies

Thanks, Hans! Works great!

Thanks, Hans. That works beautifully!

Now that that works, it exposed a flaw in my unmatched query but I’ll ask about that in a new post since it’s unrelated to this problem.

Thanks for the reply, Hans. That works great. However, I have to base the form on a query so I slightly modified your example by adding a “+1” into it.
…
If DCount(“*”, “qryPromotionEligible”, “Promote=True”) + 1 > DCount(“*”, “tblPromotionEligible”) / 10 Then
…
This appears to work just like I envisioned and so far I’m happy – so there must be some flaw in my logic. What do you think?

Thanks for the reply, Hans. That works great. However, I have to base the form on a query so I slightly modified your example by adding a “+1” into it.
…
If DCount(“*”, “qryPromotionEligible”, “Promote=True”) + 1 > DCount(“*”, “tblPromotionEligible”) / 10 Then
…
This appears to work just like I envisioned and so far I’m happy – so there must be some flaw in my logic. What do you think?

Hi, Bob.
I guess I didn’t do too a good a job of trying to state the obvious!

Seeing Longhorn advertised raised the old for me as well!

Hi, Bob.
I guess I didn’t do too a good a job of trying to state the obvious!

Seeing Longhorn advertised raised the old for me as well!

Talking about cheap “OEM” software – check out this site that showed up in my spam box today. Really seems too good to be true.

http://best-oem-sellers.biz/%5B/url%5D

Talking about cheap “OEM” software – check out this site that showed up in my spam box today. Really seems too good to be true.

http://best-oem-sellers.biz/%5B/url%5D

Hi, Tony.
Thanks for the response.
The data on the back is all the same so I think your idea would work fine for me. I’m not too concerned about waste since it’s just a small amount of ink anyway. (In my example, if we had 37 recruits it would print one card on the last page so that whole sheet is wasted anyway once we cut it out.)
Could you walk me through your solution – since I’m not sure how to go about it?
Thanks.

Hi, Tony.
Thanks for the response.
The data on the back is all the same so I think your idea would work fine for me. I’m not too concerned about waste since it’s just a small amount of ink anyway. (In my example, if we had 37 recruits it would print one card on the last page so that whole sheet is wasted anyway once we cut it out.)
Could you walk me through your solution – since I’m not sure how to go about it?
Thanks.

I use Qurb . Works great for me.

I use Qurb . Works great for me.

Thanks for the lesson, Hans.

I understand everything except I’m having a little difficulty the concept of “cumulative.” I thought that meant something along the lines of successive addition so I would expect page 6 to try to spit out 10 (1+2+3+4) extra records. Obviously, that didn’t happen so why is my thinking wrong?

Thanks for your time.

Thanks for the lesson, Hans.

I understand everything except I’m having a little difficulty the concept of “cumulative.” I thought that meant something along the lines of successive addition so I would expect page 6 to try to spit out 10 (1+2+3+4) extra records. Obviously, that didn’t happen so why is my thinking wrong?

Thanks for your time.

Hi, Hans.
You provided me with this solution several months ago and it worked just fine until the powers that be decided they wanted a change. I was able to figure out how to make the changes to make the report appear they way they want it to but now I’m requesting a little education about how part of this works – when you get a few moments.

I know MOD is the remainder so the select case takes the remainder from the division. So if there are two extras, it will use case 2. What I have not been able to figure out how it works is the numbers after the equals (=) sign. Will you explain to me what these numbers are doing? (It took me some time experimenting to stumble upon the solution I was looking for.)

I have attached the underlying module for this report showing my changes and your original numbers remmed out. (Everything is working fine – all I’m asking for is an education.)

Thank you very much.