Impossiable task, but need to be one hundred percent.

[Rubius]

I have a query that prints a bunch of stuff releative to one job number. When it prints, on the top of the printout is the name of the query. Is it possiable to make that line a variable that corresponds to the Job number??<br>So right now every report prints &quot;JOB PICK&quot; which is the query name on the top of the page. I want it to say &quot;JOB - #####&quot; where the ##### is a number that corresponds to the JOB field on the query results.<br><br>Can it be done? <br><br>thanks in advance<br>Rubius

 

[famousb]

sure, in design view;<br>1. get rid of the label that has &quot;Job Pick&quot; on it.<br>2. in it's place put a text-box that has the control of <br><b>=&quot;Job - &quot; & [Job Number]</b><br><br>note: where i have [Job Number] you have to put in the name of the field that contains the job number, but leave the brackets. <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>

 

[Rubius]

I don't know where you mean. Because this is a query, and &quot;JOB PICK&quot; is the name of the query itself. JOB PICK is what you would double click to open the query. I don't think you can make the name of a query a variable can you? Especally not a variable that is entered after you open the query..<br><br>thanks again.

 

[famousb]

ok, so you're printing directly from the query, as opposed to a report controlled by the query?<br><br>i don't know if you can change the title for that way.&nbsp;&nbsp;why not make a quick report (you can even use the report wizard).&nbsp;&nbsp;it can wind up being alot neater and cleaner, and you can put the proper heading at the top. <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>

 

[Rubius]

thanks man...thats all I needed to know. The people in the shop are wayyyyyy too stupid to figure that out!! Took me long enough to teach them this!!!<br><br>thansk again..<br>l8r