SQL error message (1 Viewer)

[Tom d]

I have attached my Final Data base, if anyone is interested.
Question, were do you execute the qyery qryselected_statistics on form frmSelected_statistics?

 

[Tom d]

I have attached my Final Data base, if anyone is interested.
Question, were do you execute the qyery qryselected_statistics on form frmSelected_statistics?

Dumb question, found my answer.

 

[Gasman]

Well please post the solution for anyone else with the same query.
That is what the forum is about after all.

 

[Pat Hartman]

As I pointed out in a different thread, you are being very shortsighted by deleting blood pressure readings. Maybe you should learn how to use a query that uses a date range instead. That way, you can control the data used to compute your average and you can compare the averages over time. What was the average for last month, is my new medication working?

 

[The_Doc_Man]

Dumb question, found my answer.

When you honestly didn't know the answer right away and had to find it by prolonged inspection, that does not qualify as a "dumb question." For the legit "I did not know" situation, there ARE no dumb questions.