Recent content by herbal

Can someone give me a quick rundown on how I would change the color of the text for a record if one column's value meets criteria? Example... My report contains Name, DOB, and Barred. Barred is the last column to be printed in a row(not sure if you needed to know this). If the value of...

problem #1 has been solved. Problem #2 - I'd really like the report to take the company name from the company property of the db properties that way I don't have to manually change every report in the db. Any suggestions?

Hello. I have a label with the following string: The membership committee hereby approves these minutes as a summary of actions taken at the membership committee meeting on __________ as evidenced by the minute wraps filed on club premises. How do I replace the _________ with today's date? I...

Bob, I got it fixed on my own. I just had to remove the dateadd portion of the where clause after the AND so that it was just [Retrieve members since what date?]. Now it works flawlessly! Thanks a bunch!

nevermind...I think I corrected it.

Something is a little screwy. First I noticed the darn thing skipped leap day(odd). Second, if I enter 3/1/04 as the date, the query doesn't return any member added on 3/1/04 of which there are 4. It seems as if the date range isn't there, but rather its just selecting the one day 2 or 3...

I have just one more question...its not really technical...I'm just a bit braindead this morning... If I subtract 3 days from the date entered....its a 3 day range or 4?

Sweet! Looks like I got them both working. Thanks for your assistance! It is much appreciated! Herbal

Nevermind, I got the first part working....was pulling from wrong table. I know....I'm retarded!

Oh...the name is legit BTW.

Actually Bob, I went ahead and created a new query before my last post and separated the two select statements. Thats when the problem occured. I tried [Members.DateJoined] and got invalid bracketing error, and I just tried your suggestion(Members.[DateJoined]), and it still asked for the...

Its asking me to input the value of Members.DateJoined. Any ideas?

I'm having a difficult time understanding what you said. If the date that the user enters does not fall on a Monday, Wednesday, or Friday then I don't want the report to run. Basically, since I don't need it to run then I guess you could use any date. The important part is making the query...

I have a report that requires the user to enter the date of a membership meeting. As it is currently, the report takes the date entered and subtracts 3 days and uses the two dates for the range. I'd like the report to make it subtract 3 days only if the date entered by the user is a Monday...

What you said makes perfect sense. I don't think I was clear enough though. I'm trying to make it so that at the end of the report it will list the number of Expired members followed by the number of Added members, and then the number of active members. Sorry for my poor communication.