bracket parameter query

[Old Timer]

Developed database for County Auditor's office. Input user needs a report "Button" placed on program menu that reads a predesigned query and outputs to the report (2) specific answer's from the database.

I use a bracket [ Enter year needed] in criteria of year field, OK, I then put a bracket in $Consideration field [ Place >dollar amt and <dollar amt] the parameters come up fine, "year" then "$Consideration".

BUT I get a blank answer. What is missing ???

When I run the same query manually year field criteria "2003" $Consideration field criteria ">50000 and <100000" I get the entire answer just fine. Why won't the bracket parameter work ?

I need the query to work so I can have a macro that opens a report, which in turn uses the designed bracket query as a source. That way I can give her a button on menu which will run the report as needed.

When the button is depressed it opens and runs the report, the report would of course gather its information with parameters needed as asked for by the criteria brackets in the source query.

The computer operator could put in the needed year and various changing amounts of dollar values (High dollar amt and Low dollar amt) as asked by appraisers. The report would output to screen and could be printed.

Appaisers ask for properties over $125000 and under $150000 or over $30000 and under $750000 for another instance to stay inside a buyer request.

Manually it works,--- by bracketed query fields it doesn't ---. I run all kinds of bracket query's for address labels by the year. various text information, but this one sticks someplace. Is it becasue of dollar amounts ???

Will really be appreciated for some help on this one.

 

[dcx693]

I use a bracket [ Enter year needed] in criteria of year field, OK, I then put a bracket in $Consideration field [ Place >dollar amt and <dollar amt] the parameters come up fine, "year" then "$Consideration".

I didn't really read the rest of your post , but the syntax of the second parameter is not correct.

As far as I know, you cannot input a string like ">50000 and <100000" and have Access evaluate it the way you want it to. It works manually, but not when using a parameter query.

You need to prompt for each of the parameters individually. Use something like this in your Consideration field:
Between [>dollar amt] And [<dollar amt]

 

[Old Timer]

bracket query's

Thanks for the reply. I shall give a try right after lunch. At 78 some of these things come a little harder for me than they used to. I appreciate all the help kind people give me. Old timer

 

[Old Timer]

Dcx693

Thank you, you have made my day. The difference in the query was the BETWEEN it works just fine. I will go up to the Court Office and using my "thumb drive" to transfer the files. transfer the query, report and switchboard into her computer. She will be thrilled to death. She will think I am some kind of hero, and I'm not. Its kind people taking their time like you that keeps me upright and going. Old Timer

 

[dcx693]

You're welcome. Just for trying to use Access at the age of 78, you should be considered a hero.

 

[Old Timer]

Old timer

You're welcome. Just for trying to use Access at the age of 78, you should be considered a hero.

Thank you it helps keep my mind going. My body is not very able anymore but it doesnt take much energy to operate a keyboard. I was pretty good with Paradox 4.5 the past DOS program and developed many programs for the county. They ran them for 8 years, now they have upgraded to Windows 2000. Was still trying to use the same DOS programs. I had retired from active work many years ago with them. But they knew I still loved computers and asked if I could do anything for them, being I had developed the original programs and understood the working of the county and needs of the departments.

I contracted for each program in turn as I finished it in Access 2000. Using a thumb drive I can work at home and carry my changes and updates to them in my pocket.

I get hung up now and then, but kind people like yourself have helped me out each time. Again thank you.