Updating datasheet

[beansmom]

I am creating a number of charts that trend lab results over a number of days. One lab test per chart. I used the first chart as a template (created with the wizard) and then just copied it and changed it's Record Source and Row Source to reflect the correct query. This was working okay, but then I ran into a problem because the data in my datasheet was not changing from report to report.

I found a thread (703-1070136) that addressed this and tried to copy and paste from the Row Source query. However, I am getting an error when I try to run the query: "You can't specify Group By, Expression, or Where in the Total row for this column."


Int([DateDone]) DateDone Result Result
Group By Group By Group By Expression
Row Heading Value Column Heading


Any help is appreciated. Thanks is advance!

 

[dhookom]

Your "Value" column must not be "Group By". It can be Max, Min, First, Last, Sum, Count,...

Do you understand how to use the Link Master/Child of your chart control? This might allow you to create one chart and have it display different tests based on the test value from your report.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[beansmom]

Hi Dhookom- I tried changing the Value column to all of your suggestions and they all produced the same error.

 

[dhookom]

What is the data type of [Result] and why would you use [Result] as both the value and the Column Heading?

Can you tell us more about your data and what you are attempting to do?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[beansmom]

I have a table with lab tests. There is a date the test was done, the test name, and the result. The result could be a numeric or text, so the data type is text, so that is why the error. I ran the original report through the wizard, so it set things up for me. Thanks for your help.

 

[dhookom]

Even if the lab result is text, you should be able to use this field as the Value of the crosstab if you select "First" or "Last" or "Min" or "Max".

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[beansmom]

No. I still get the error. I think I need to let this issue go. Charts are not necessary to this project. I was just trying to add an extra for them. I appreciate your help and I am sure you could have gotten me where I needed to go, but I am out of time.