Company logo in report header

Hello all,

I've made quite a few reports for my company and each one has the company logo stored in the report header as an image.

I also have a job title and number in the heading that just describes the current job.

The problem is that firstly, I've added the logo top every report and therefore it is stored about 20 times! The other problem is that if I wish to change the job title, then I have to edit the report each time. This is fine if I am doing it (because I made the report) but I'd like to avoid this so that other users aren't involved in too much editting etc.

My idea is to have a table called "Job_Info" with the following fields: "Job_Logo", "Job_Title", and "Job_Number".

In this table I can store various different job names, logos numbers etc. eg

[LOGO1], First Job, 0001
[LOGO2], Second Job, 0002
etc.

I then wish to create a query and form which allows the user to select one of these records (current job).

I then would like to try and get these three fields to appear in the report header, including the logo. At the moment, the main report info comes from a seperate query.

I'm having trouble calling the information from the table. I get error messages saying cannot find field. I assume this is because the info I'm calling is in a table seperate to the main query.

Is there any way I can call this table (or query) which adds the currently selected company logo and info?

Thankyou to anyone that helps,

Bakerboy

For Imagedatatype i have not tried. For rest of the datatype You can use Dlookup command .

Place the following in a textbox in the report header (including = symbol)

=Dlookup("RequiredFieldtobedisplayed","FromTable","Jobbumber = '0001")