Joining unrelated data in query

  • Thread starter Thread starter kemosabe
  • Start date Start date
K

kemosabe

I want to take a single "StartDate" field from a table "Dates" and include it
on every record in a query "qry_tblShipmentTotals_ASSOCID". The "StartDate"
field is used in multiple queries, so I have it being input via a form into
the "Dates" table one time (to prevent having to enter it over and over again
until it changes). There are expressions in the
"qry_tblShipmentTotals_ASSOCID" that use the "StartDate" value. Ideas?
 
You can add the Dates table like you do any other table in a query, but you
don't need to join it. If it only has one record, you can just use the
StartDate field to your query as normal.

Your problems come when more than one record exists in the Dates table.
 
If your table Dates has a single record you can add the table without joining
and have no ill effect. If there are multiple records then you will have a
Cartesian effect that multiples the number of records in one table by the
number of records in the other table.

In SQL the tables would be separated by a comma in the FROM statement.
 
Back
Top