Enter Parameter Value

[paulreed]

I have a query which comprises of [data1], [data2] and an expression [Percentage: ([data1]/[data2])], which formatted as 'percentage' gives me the percentage using the other two peices of data. This works fine, except I want to add a criteria in the criteria box - for example >0.2, to show only records over 20%, but it doesn't work!
When I run the query, I get a input box;
'enter parameter value' - data 1
instead of the query obtaining the data from the query field [data1].

Any ideas?

 

[dcx693]

'enter parameter value' - data 1

When it pops up that dialogue box, is that exactly how it displays the message? Is there a space between the "data" and "1"?

 

[paulreed]

When it pops up that dialogue box, is that exactly how it displays the message? Is there a space between the "data" and "1"?

Sorry, (typo) it displays 'data1'. If I enter a value or just OK the box, I get a further dialogue box requesting parameter value - 'data2'.

I have simplified the question, because the actual query does contain other fields, which do a number of calculations, but I am just having trouble with the percentage one, which although functions OK, does not allow me to apply a filter criteria.

 

[dcx693]

Is there only one table in this query? Or are there multiple tables with fields called [data1], [data2] ? Why don't you post the SQL of the query?

Not sure why this is happening, but try putting the table names in front of the field names like

.[data1]. See if that makes a difference. If not, perhaps defining the query parameters in the Query, Parameters menu will help.

 

[paulreed]

Is there only one table in this query? Or are there multiple tables with fields called [data1], [data2] ? Why don't you post the SQL of the query?

Not sure why this is happening, but try putting the table names in front of the field names like

.[data1]. See if that makes a difference. If not, perhaps defining the query parameters in the Query, Parameters menu will help.

There is 2 tables in the query, and the tables are linked by [data1]. I have gone through the query and added the table names throughout, still no luck.
The data from the query is sent to a mailmerge Word document, fortunatly, I can filter the percentage from Word, so I think that I will just accept defeat, and filter it from there.

Thanks for your help