Search results for query: *

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.

you're the bomb! Ok....god...I know I'm gonna make you crazy....but...I setup a calculation in my report to count expired and added members. If I put the textboxes with calculations in type header...they both get the same total which is incorrect. It is the first group found that is counted...

Nabi, Any idea why the original SQL statement you gave me on this would ask for first date and last date of added members, but then only ask for the first date of expired? Honestly, I'd like to make them be the same dates so as to only enter the date range one time. Thanks again...

I need to just add a count of records by group. To be more specific I need a count of added records, and a count of expired records. Here's the SQL statement: SELECT 'Expired' As [Type], ExpiredMembers.FirstName, ExpiredMembers.MiddleName, ExpiredMembers.LastName, ExpiredMembers.DateUpdated...

Nabi....your knowledge of Access is unfair! Great suggestion! On to the next problem. Thanks a million! Herbal

nabi...I just noticed that the SQL statement you gave me earlier works great except that for some reason the added members DateJoined and DateExpired are NULL just like the expired. I looked over the SQL statement and I don't really see any problems. You have any suggestion as to why this is...