Query Tables

[Guest]

I have an existing report query that serves its purpose well. I would like
to pull in unrelated data (sunrise/sunset times) into the report. I find
that if I simply add the unrelated table to the report query; it works well.
However; I feel I must be violating some database rule by having several
tables feeding my query and one single table with no joins to the others?
Like I said; it works but I would like to know if this solution is sloppy.

 

[Guest]

If you display this data of the sunrise/sunset times only once in the report,
then use dlookup to retrieve the value from the table that contain the time

In the ControlSource Property of the time field you can write
=dlookup("FieldName","TableName")

Check help on dlookup.

 

[John Spencer (MVP)]

If it works, then it works. And your solution is probably the best for this situation.