(Link to AcmlmWiki) Offline: thank ||bass
Register | Login
Views: 13,040,846
 Main | Memberlist | Active users | Calendar | Chat | Online users
Ranks | FAQ | ACS | Stats | Color Chart | Search | Photo album 		05-18-24 06:41 PM
0 users currently in Hardware / Software.
Acmlm's Board - I3 Archive - Hardware / Software - Bizarre Query Problem in Access New poll | |
Add to favorites | Next newer thread | Next older thread
User Post
beneficii

Broom Hatter


 





Since: 11-18-05

Last post: 6302 days
Last view: 6298 days
Posted on 02-28-06 02:45 AM Link | Quote
Hi y'all, I'm wondering if any y'all can help me with a bizarre problem in Access (which I think makes no sense to be a problem; NO SENSE AT ALL!). Here follows:

I set up a query, in which there are 3 columns, with 2 of the columns supposed to be invisible when the query is run. The first column sets up the count of the number of times a specific item has appeared in a field and stores it in an expression, the second column takes the expression and multiples it by 10 and stores it in a second expression, and the third column takes that second expression and adds a "%" to the end of it.

Here's where the problem appears. Well, when all 3 columns are visible (with the Show checkbox checked), the query runs fine and that third column shows exactly what I need it to. However, for the first 2 columns that are supposed to be invisibile, to work in the background, when those columns' Show checkboxes are unchecked, then every time I run the query, it asks me for the parameter in one of the 2 expressions. It opens up the "Enter Parameter Value" window and asks me to give the parameter. That does not make any sense at all to me, why it has to ask me for the parameter just because the expression column is invisible when the query runs.

Because my teacher would disapprove, I will not put the MDB on-line, but any person with access can set this up themselves and see. It would be most helpful if y'all could help me get around this stupid problem that shouldn't even be a problem. Thanks.

EDIT: I tried to get around it by making 2 queries, but it still asked me to "Enter Parameter Value" for each of the expressions which weren't in the expression.

(edited by beneficii on 02-28-06 01:51 AM)
Add to favorites | Next newer thread | Next older thread
Acmlm's Board - I3 Archive - Hardware / Software - Bizarre Query Problem in Access |


ABII

Acmlmboard 1.92.999, 9/17/2006
©2000-2006 Acmlm, Emuz, Blades, Xkeeper

Page rendered in 0.005 seconds; used 353.30 kB (max 411.95 kB)