Search results

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

I created an Access97 report that is printing a blank page after every page of data. Actually, there is a small symbol on each blank page but the symbol is not on the keyboard for me to show here. Any ideas on what is creating the extra page to be printed? Thanks. Tom

I did mark the form as data entry which gives me a blank screen to start with but it prevents me from seeing which record number I am adding ie 177 of 177. Instead it shows record 1 of 1 even thought the table has 176 records in it. Also, the Find button no longer works, it appears the other...

I have an entry for that when started displays the first record in the table. I have to hit the "new record *" key to get a blank screen with my autonumber displayed. How do I get the form to go immediately to the new entry, autonumber state? This will save a step for my user. Thanks for the...

I have a form with numerous data fields on it. When I click on a checkbox field, I automatically open a second form for additional data entry. I want to pass some of the fields (SSN, Name, EMP#,etc.) onto the second form. The problem I'm having is the data being passed to the second form is...

Thanks Rich & Chuck for the reply. Rich, you were correct, it was in a query. I am new at Access and thought the report was coming directly from a query. Now I know how to do this for other reports I need to create. It seems easy once you know how but finding where things are happening can be...