RE: Enter Parameter Value Issue when running query with 2 tables
- From: Duane Hookom <duanehookom@xxxxxxxxxxxxxxxxxx>
- Date: Sat, 20 Jan 2007 12:35:23 -0800
I would first go back to your crosstab query and change the Column Heading
value to replace Nulls with some real value using Nz().
Then, I would search the web on Access/vba naming conventions. Find one that
meets your needs and stick to it. Most of us that have been around for a
while never use spaces, symbols, etc in any field, table, or other object
name. Tony Toews has some recommendations at
http://www.granite.ab.ca/access/tablefieldnaming.htm. There are many others.
--
Duane Hookom
Microsoft Access MVP
"kswan" wrote:
I have two queries that are being used in order to calculate a percentage..
When running the query there is a parameter value error looking for one of
the tables. The issue may be around null values but I don't know how to
resolve. The null values are needed in the output and the pecentage if
applicable.
There is also a field in the first query that gives the number and
percentage of completed records. Not sure if that is the issue.
count of 4-12 w Y_qry allows the percentage to be calculated.
Here is the SQL
SELECT [Rating by tier 4-12_Crosstab].Tier, [Rating by tier
4-12_Crosstab].[Total Of Emplid] AS [# of EE], IIf(IsNull([BLANK
%]),1,(1)-[BLANK %]) AS REPORTED, [Rating by tier 4-12_Crosstab].[<>],
[<>]/[count of 4-12 w y_qry].[Total Of Emplid] AS [Blank %], [1]/[count of
4-12 w y_qry].[Total Of Emplid] AS [1's], [2]/[count of 4-12 w y_qry].[Total
Of Emplid] AS [2's], [3]/[count of 4-12 w y_qry].[Total Of Emplid] AS [3's],
[4]/[count of 4-12 w y_qry].[Total Of Emplid] AS [4's], [5]/[count of 4-12
with y_qry].[Total Of Emplid] AS [5's], [Y]/[count of 4-12 with y_qry].[Total
Of Emplid] AS [Y's]
FROM [Rating by tier 4-12_Crosstab], [count of 4-12 w Y_qry];
Any help would be greatly appreciated.
- Prev by Date: Re: Controlling Query Output with Checkbox on Form
- Next by Date: Re: drop down list within a query?
- Previous by thread: Re: Controlling Query Output with Checkbox on Form
- Next by thread: RE: Enter Parameter Value Issue when running query with 2 tables
- Index(es):
Relevant Pages
|
