The Microsoft Jet database engine not rocognizing

[skilche1]

Start with: frm_W-GraphSearch
select from combo and ever this for date criteria: 12/1/06 to 12/13/06
Open report - There you will see one out of three graphs showing
Go to Report Design mode and open the sql in one of the graphs and try to run it, there you see the error:

"The Mocrosoft Jet engine does not recognize 'Forms![W-GraphSearch].Text0' as a valid field name or expression."

Anyone have any ideas?

Thanks again in advance for your help,

Kilch

 

[boblarson]

Yeah, you put the criteria in the wrong field. You put it on DateID instead of the date field.

 

[skilche1]

bob, thanks for your reply.

Actually, if you look at the "W-WeightChart query", it is already set up in that manor, where the date criteria is in the DateId Column.... Unless I am misunderstanding you. I am on the wrong course, could you please more specific?

Thanks again,

Steve

 

[boblarson]

You are misunderstanding me. You, in fact just said what is true: the date criteria is in the DateID column, but you should have it under the DATE field (which by the way you should not use an Access reserved word as a field name). I'm not sure why you are even having a date table with just the date in there as you are storing the date in the Scrap Weight Data table anyway. But, just so you know if you change the criteria to be on the DATE column in your query instead of the DateID (which I can see is a date) it actually pulls records when it doesn't when it is on DateID.

 

[skilche1]

You are misunderstanding me. You, in fact just said what is true: the date criteria is in the DateID column, but you should have it under the DATE field (which by the way you should not use an Access reserved word as a field name). I'm not sure why you are even having a date table with just the date in there as you are storing the date in the Scrap Weight Data table anyway. But, just so you know if you change the criteria to be on the DATE column in your query instead of the DateID (which I can see is a date) it actually pulls records when it doesn't when it is on DateID.

Yea, OK. I just tried (again) and I still get the same results. Nothing on the bottom two graphs. As far as the Date Table is concerned? I set it up that way for navagation purposes. lol I know, not very smooth, but then again, I am not a pro at Vba.

Got anymore ideas? Have you been able to generate a graph? I can pull the data up without any issue in the Query, but for some reason, it will not show up on the graphs.

Thanks again for your help.

Clueless

 

[boblarson]

Sorry, my misunderstanding of the question. I'll check out the graphs as soon as I can.

 

[skilche1]

Sorry, my misunderstanding of the question.

Sorry for the being confusion. I appreciate your help.

Thanks bob.

 

[skilche1]

Bob,

Have made any progress?

Thanks,

 

[boblarson]

Sorry - I did find out that in your aggregate query, that if you get rid of the last column, the query seems to work. If you put that query inside another query and add that last column (I don't remember the name right now, but it was the Sum expression) in to that second query, it seems to work fine. But as for the graphs, I haven't figured out those.

 

[skilche1]

Sorry - I did find out that in your aggregate query, that if you get rid of the last column, the query seems to work. If you put that query inside another query and add that last column (I don't remember the name right now, but it was the Sum expression) in to that second query, it seems to work fine. But as for the graphs, I haven't figured out those.

hmmmmmm. It seems to work fine when I run the query with all columns in tack. This is really getting frustrating to say the least.

I have just tried setting up the query the same way the SQL for the graph and seems to work fine when I run the query. When I try to create the graph with that query, I get the same error. ugggggg........

Not sure how I'll accomplish this...

 

[boblarson]

I'm sorry I'm not able to provide an answer on this one. I know it's gotta be driving you nuts. If I get a chance I'll keep trying as well.

 

[skilche1]

I'm sorry I'm not able to provide an answer on this one. I know it's gotta be driving you nuts. If I get a chance I'll keep trying as well.

Thanks bob for your efforts. Because I cannot access any other sites from my work, could ask you to possibly post this question on any other forums that you are a member of? I have site restrictions and they will not allow me to access any other sites. People here were mis-using the internet and it effected us that really need to access it. If not, I understand.

Well, thanks again for your efforts.

Steve

 

[skilche1]

On thing that I have noticed is that when I remove the criteria from the query, it seems to work fine in the graph. On that note, it's not liking the formula for some reason. This is the first time I have ever ran acrossed this. uh????

 

[skilche1]

Is there anyone that can help me out here? This is the fdicussion forum I can access from work, so I cannot look elsewhere.

Thanks,

Kilch