Use info from settings table in a report

[wackywoo105]

I have a main table and a settings table. The settings table only has 1 id number and a few data fields and updated on an annual basis.

I generate reports using a query on the main table but want to add in some of the data from the settings table.

I am struggling with how to link the tables or otherwise pull the data from the settings table into the report. The tables don't really need to be linked as they don't have a relationship, the settings table is only 1 line.

Does anyone know how to do this?

 

[NauticalGent]

Are there any common fields in the main table and the settings table?

 

[sneuberg]

You could use DLookUp or if they are in one place in the report put them in a subreport.

 

[wackywoo105]

Tanks all. There is no relationship between the tables. Dlookup did the trick.

 

[HiTechCoach]

Tanks all. There is no relationship between the tables. Dlookup did the trick.

Note: You don't have to join tables in a query.

If there is one a single record in the settings table then you don't have to set a relationship. Just add the settings table to the query. Add the required fields to the query output.

I have been using a table with a single record and no join to pass data to a query since back in the 1990's. Probably as far back as Access 2.0.

FWIW: I avoid DLookup() because it can have a negative impact on performance.

 

[sneuberg]

FWIW: I avoid DLookup() because it can have a negative impact on performance.

How could a DLookUp on a table with a single record have a negative impact on performance?

 

[HiTechCoach]

How could a DLookUp on a table with a single record have a negative impact on performance?

Extra Overhead