Help With Charts One Not Working Now and One I Can't Figure Out 1

[Elvis72]

I have this query below:

SELECT TblProjectInformation.JobProposalNo, TblConstructionServices.Title, Count(TblProjectInformation.ProjectID) AS CountOfProjectID, TblDate.TheDate, TblProjectInformation.[HR Classification], Count(TblProjectInformation.[HR Classification]) AS [CountOfHR Classification]
FROM TblDate, TblConstructionServices INNER JOIN TblProjectInformation ON TblConstructionServices.JobProposalNo = TblProjectInformation.JobProposalNo
WHERE (((TblDate.TheDate) Between #1/1/2004# And #1/1/2025#) AND ((TblProjectInformation.[Mobilization Date])<=[tblDate].[TheDate]) AND ((TblProjectInformation.[Demobilization Date])>=[tblDate].[TheDate])) AND (((TblProjectInformation.JobProposalNo)=[Enter Job/Proposal Number]))
GROUP BY TblProjectInformation.JobProposalNo, TblConstructionServices.Title, TblDate.TheDate, TblProjectInformation.[HR Classification];

Which when you go through the query it works fine, but when I use the Chart on the Form it comes up again with this error:

The Microsoft Jet database engine does not recognize '[Enter Job/Proposal Number]' as a valid field name or expression.

Like I said it was working, I don't know what I did to break it?

Also, I have the following information:

JobProposalNo Title CountOfProjectID TheDate HR Classification CountOfHR Classification
1169238010 3rd Project 1 01-Feb-06 Local 1
1169238010 3rd Project 1 01-Mar-06 Local 1
1169238010 2nd Project 1 01-Mar-06 OCN 1
1169238010 3rd Project 3 01-Apr-06 Employee 3
1169238010 3rd Project 2 01-Apr-06 Local 2
1169238010 2nd Project 4 01-Apr-06 OCN 4
1169238010 2nd Project 3 01-May-06 Employee 3
1169238010 2nd Project 2 01-May-06 Local 2
1169238010 3r Project 8 01-May-06 OCN 8
1169238010 2nd Project 7 01-Jun-06 Employee 7
1169238010 2nd Project 3 01-Jun-06 Local 3
1169238010 3rd Project 15 01-Jun-06 OCN 15
1169238010 2nd Project 9 01-Jul-06 Employee 9
1169238010 2nd Project 5 01-Jul-06 Local 5
1169238010 3rd Project 19 01-Jul-06 OCN 19
1169238010 2nd Project 9 01-Aug-06 Employee 9
1169238010 2nd Project 6 01-Aug-06 Local 6
1169238010 3rd Project 21 01-Aug-06 OCN 21

Out of this I need to produce a chart that shows the following:

Total Number of Employees
200 --- 2nd Project === 3rd Project

150

100 =======
======== ===================
50 ==== --------
----- ------ --------------
0--- ------
-------------------------------------------
Date Date Date Date Date Date Date

The Project Personnel Count data is where I am having the issue, when I select stacked it is showing me the date one in front of the other and I need to to actually stack on top of each other so you see the Total number of personnel out in the field on the chart.

If that makes any sense.

I just came back from having knee surgery and my brain seems to still be a little foggy from the happy pills they sent me home with. Because I know this isn't as hard as I am making it out to be?

Thanks soooo very much!~

 

[genomon]

The Microsoft Jet database engine does not recognize '[Enter Job/Proposal Number]' as a valid field name or expression.

That's because it's expecting you to enter a parameter, which you can't do with the chart tool. There is an ActiveX graph tool that you may be able to get away with; I haven't used it in years, so I can't say for sure. It's under "more tools" (the ellipsis) in the toolbox.

"Don't be irreplaceable. If you can't be replaced, you can't be promoted."

 

[dhookom]

First, IMHO parameter prompts are not good user interface faq701-6763.

When your Row Source is a crosstab query, you must enter the data types of your parameters into your query:

Parameters [Enter Job/Proposal Number] TEXT (255);
SELECT TblProjectInformation.JobProposalNo, TblConstructionServices.Title, Count(TblProjectInformation.ProjectID) AS CountOfProjectID, TblDate.TheDate, TblProjectInformation.[HR Classification], Count(TblProjectInformation.[HR Classification]) AS [CountOfHR Classification]
FROM TblDate, TblConstructionServices INNER JOIN TblProjectInformation ON TblConstructionServices.JobProposalNo = TblProjectInformation.JobProposalNo
WHERE (((TblDate.TheDate) Between #1/1/2004# And #1/1/2025#) AND ((TblProjectInformation.[Mobilization Date])<=[tblDate].[TheDate]) AND ((TblProjectInformation.[Demobilization Date])>=[tblDate].[TheDate])) AND (((TblProjectInformation.JobProposalNo)=[Enter Job/Proposal Number]))
GROUP BY TblProjectInformation.JobProposalNo, TblConstructionServices.Title, TblDate.TheDate, TblProjectInformation.[HR Classification];

Duane
Hook'D on Access
MS Access MVP

 

[Elvis72]

Duane -

I tried the information above and I am getting this:

This expression is typed incorrectly, or is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables.

At the end of the day I have to have the ability to run a chart for a specific JobProposalNo, It seems like this is going to be either highly complicated or not possible.

 

[dhookom]

Is your JobProposalNo text or numeric?

This shouldn't be any major issue to work through.

Duane
Hook'D on Access
MS Access MVP

 

[Elvis72]

Boy did I have a DUH moment when I read that.

Works perfectly!~

Thanks~