Queries combining constant and variable data

[RMires]

I am trying to create a Query using two groups of data, one constant the
other static. For example, the first group are data on storage tanks ie. max
volume. There is one table for each tank so there is only on record per
table. The second group are daily information ie. actual volume. I want the
query to perform calclulations using both sets of data, for instance the room
available in a tank. Since the first group is a constant table and the other
has one record per day, I believe I am having trouble with the relationships.

 

[Duane Hookom]

If there is only one record from one of the tables, you don't need to set a
relationship. For instance if you have a table "tblApplicationVersion" with
only one record and fields like "VersionDate" and "VersionNumber", you can
place these values in any report by just adding tblApplicationVersion to
your report's record source. As long as there is at least on record in your
other table(s), you can then add VersionDate and VersionNumber to each
report without having any effect on other records/fields.

 

[RMires]

But I'm trying to create a query, not a report. And when I do, it says "there
are no relationships between the tables" or something to that effect. Is that
only because I'm trying to use the Wizard?

 

[Duane Hookom]

Probably due to the wizard. You can create queries without the wizard or
modify them once the wizard is packed up and gone home.