THE PROBLEM WITH THE DIAGRAM

[Lilian]

Hi!
How to make a diagram in the form that takes data from other forms in the db?
Best regards,
Lilian

 

[John W. Vinson]

Hi!
How to make a diagram in the form that takes data from other forms in the db?
Best regards,
Lilian

Please explain your question.

What kind of "diagram"? A Graph? A relationships diagram?

Forms do not contain data, so you can't "take data from other forms in the
db". Data is stored in Tables; forms are just windows to display it.

More info please!

 

[Mike Painter]

Please explain your question.

What kind of "diagram"? A Graph? A relationships diagram?

Forms do not contain data, so you can't "take data from other forms
in the db". Data is stored in Tables; forms are just windows to
display it.

More info please!

WAG. Query builder?

 

[John W. Vinson]

Hi!
I have three form in which calculates some data I want to present the total
result of these data on the separate form in 3d graph?
Best regards,
Lilian

Do the calculations in a Query, and base the graph on that Query. That will be
much simpler than trying to reference three different forms.

 

[Lilian]

Hi John!
I made a query based on these three forms which don't have any connection
with each other except connection to 4 form projects . The data represents
incorrectly when I try to execuate query it shows data 5 times more that it
should be. I tryied with UNION and GROUP BY but it doesn't help. Can you
recommend me what to do in such situation?
Best regards,
Lilian

"John W. Vinson" skrev:

 

[John W. Vinson]

Hi John!
I made a query based on these three forms which don't have any connection
with each other except connection to 4 form projects . The data represents
incorrectly when I try to execuate query it shows data 5 times more that it
should be. I tryied with UNION and GROUP BY but it doesn't help. Can you
recommend me what to do in such situation?

Correct the error in your query. I expect there's a cartesian join somewhere;
if the forms have the same "shape" of data it's likely that you'll want a
UNION query (stringing records together end to end) rather than a JOIN query
(joining records side by side).

If you would like help doing so post the SQL and enough of the context that
someone who can't see your database would be able to figure it out.