Query Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
If it works, then it works. And your solution is probably the best for this situation.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete Query: Could not delete from specified tables 0
Have both records from two queries/tables under one Query without related fields. 0
Query based on two unrelated tables 2
Make table query: [Enter 1] AS Test 1
Can't create a report from my query in Access 1
Query with three tables 3
Left join in query 12
Unrelated table 1

Back
Top