Recent content by tcaprice

thanks for the tip Chad, I'll take a shot at it. It sounds like more than I've done up to now but I'll give it a try. I guess there is no such thing as a wild card for a numeric field?

Hi, I have a query that prompts with a parameter box for the field Contributor_ID. Contributor_ID is a numeric field & Key and I use it to allow the user to print a report based on which Contributor_ID value the user enters. This works fine. However, I would like the user to have the option...

Thanks Rich, it worked great!

I am trying to print the & character on a report but it does not display. It is a Label box that I want to display Systems & Sensors on but it prints without the & character as Systems Sensors My guess is the & is a special character in Access but is there a way to turn that off and it...

Thanks for the help, followed your lead, problem resolved. Thanks again.

The statment below worked for me in this database while the database was in Access97. Now that I've converted the database to Access2000, this query no longer works, I get the message: Undefined Function 'Left' in expression. SSN...

Pat, You are right about the poor table design. I have been resisting going back and redesigning but it's become pretty evident from the reporting requirements that a table redesign is in order. I could have gotten by if I could assign more than 1 value at a time in the iif but based on your...

I currently have an iif statement that creates a value in a new field name based on a value in an existing field name. Example: SELECT [EMRB MASTER].LMPID, [EMRB MASTER].[Last Name], IIf([EMRB MASTER].[SPMES Promotion]=-1,"SPMES") AS CURRJOB FROM [EMRB MASTER]; if the SPMES Promotion field...

Jon K and RV, Thanks to both of you for your replies, I did use the examples supplied and they worked very nicely, problem solved! Thanks again. Tom

I have a form with 6 different Job Code fields on it. Each field is a check box, each is a field in the employee table. Each time a person gets promoted, the next Job Code field gets a check mark but the prior check mark still contains the check along with promtion date, amount, etc. I want to...

Jon K, Thank you so much!!! Worked like a charm. Awesome to be able to key in the amount vs. numerous hard-coded queries. I had never worked with the Parameter column/data type setting before. FYI, to anyone else reading this, I did have to do both things Jon recommended. It did not work...

I have a query where I calculate the Annual Contribution Amount with the following statement: Annual$: ([Current DEDUCTION]*52) With my query, I also want to select only those records that have a calculated amount greater than the amount I will enter in a parameter. I normally enter a...

glycnh, Thanks for the suggestion. I worked on it prior to seeing your method and I have solved my problem though thru a less sophsticated method than you propose. I ended up creating a macro where I had the first query do a random select and create a "Winner" table with the record selected...

Here's my scenario: I have a query that randomly selects a record from an Employee Table for a prize drawing. This query is the source for a report that prints out a pretty "your the winner"document. All of this is working well. However, what I'd like to do and can't figure out how is: For...

Chris, Thanks so much, that's exactly what it was. All looks good now, appreciate the guidance. Tom