Report based on query

[Soulfly]

hello everybody,

Im facing the following problem.
I have several tables with information about one subject, now I want to place all the information from the subject in one report. Now I know I can do this with a query with loads of joins, but when I try this I don't get any result.

Is it possible to fill fields in a report based on a query? Say something like

me.test.text = "Select year from tbltest where city = " me.test.value

I hope my problem description is enough, otherwise I'm more than willing to explain.

Thanks,

Peter

 

[RV]

If your query doesn't return any results, my guess is that you're using INNER joins.
Try changing them into either RIGHT joins and/or LEFT joins.

I have several tables with information about one subject

If the table structures are similar, use one table instead.
My wild guess is that your applic is not normalized.
Which sooner or later will result in severe headaches

RV

 

[Soulfly]

If the table structures are similar, use one table instead.

RV

RV, thank you, I was also thinking of combining the data in one table,but my master table is an import of an export from an other database. This table contains loads of fields, I don'tknow in any way how to update a single table if there are fields that aren't in the import file.

If you have any tips to update such an table I'm more than willing to listen

thank you,

Take care

 

[cuttsy]

If you are struggling writing a large qurey with many tables and joins then you can try writing it in parts. Write a query that joins 2 of the tables, get it working how you want call it query1(no don't call it something sensible and meaningful) then do another query joining 2 of the tables, query 2. Then write a query that joins query1 and query2. that might be easier for you to follow. It's not the best way to do it but it's better than nothing at all.

This way you can tell which stage you are getting wrong.

 

[Soulfly]

Hi there Cuttsy,
That is indeed a good way to test the working an come to an result. I will try it. Thank you!!