Show name in the report header

[pukhton]

I want to print a report in Access, where I can show the name on top the report when user enter name. please take a look.

I have this so far in the header of the report

 
=Forms!RunReport!Pharmacist.Value
 
 

I want something like that

"Interventions by location by "Pharmacist Name"

 
PARAMETERS [Enter Pharmacist Name] Text ( 255 ), [Start Date] DateTime, [End Date] DateTime;
SELECT Intervensions1.Location, Count(Intervensions1.fldID) AS CountOffldID
FROM Intervensions1
WHERE (((Intervensions1.Pharmacist) Like "*" & [Pharmacist] & "*") AND ((Intervensions1.Date) Between [Start Date] And [End Date]))
GROUP BY Intervensions1.Location;
 
 

[mlcampeau]

I want to print a report in Access, where I can show the name on top the report when user enter name. please take a look.

I have this so far in the header of the report

 
=Forms!RunReport!Pharmacist.Value
 
 

I want something like that

"Interventions by location by "Pharmacist Name"

 
PARAMETERS [Enter Pharmacist Name] Text ( 255 ), [Start Date] DateTime, [End Date] DateTime;
SELECT Intervensions1.Location, Count(Intervensions1.fldID) AS CountOffldID
FROM Intervensions1
WHERE (((Intervensions1.Pharmacist) Like "*" & [Pharmacist] & "*") AND ((Intervensions1.Date) Between [Start Date] And [End Date]))
GROUP BY Intervensions1.Location;
 
 

You could try creating a textbox in your Report Header with the following:

="Interventions by location by " & Forms!RunReport!Pharmacist.Value

I haven't tested this so let me know if it works. I know this method would work if you had the prompt for Pharmacist Name in your field list for your report. I'm not sure if the above query is for your report or for your form.

[pukhton]

You could try creating a textbox in your Report Header with the following:

="Interventions by location by " & Forms!RunReport!Pharmacist.Value

I haven't tested this so let me know if it works. I know this method would work if you had the prompt for Pharmacist Name in your field list for your report. I'm not sure if the above query is for your report or for your form.

Thanks for your reply. i tried that, but it still giving me an error #Name?

NOT SURE WHATs wrong with it?

[mlcampeau]

is the above query the record source for your report?

[pukhton]

is the above query the record source for your report?

Well this is the query for my Interventions by location by pharmacist, so yes this is the record source for my report.

 
PARAMETERS [Enter Pharmacist Name] Text ( 255 ), [Start Date] DateTime, [End Date] DateTime;
SELECT Intervensions1.Location, Count(Intervensions1.fldID) AS CountOffldID
FROM Intervensions1
WHERE (((Intervensions1.Pharmacist) Like "*" & [Enter Pharmacist Name] & "*") AND ((Intervensions1.Date) Between [Start Date] And [End Date]))
GROUP BY Intervensions1.Location;
 
 

[mlcampeau]

Well this is the query for my Interventions by location by pharmacist, so yes this is the record source for my report.

 
PARAMETERS [Enter Pharmacist Name] Text ( 255 ), [Start Date] DateTime, [End Date] DateTime;
SELECT Intervensions1.Location, Count(Intervensions1.fldID) AS CountOffldID
FROM Intervensions1
WHERE (((Intervensions1.Pharmacist) Like "*" & [Enter Pharmacist Name] & "*") AND ((Intervensions1.Date) Between [Start Date] And [End Date]))
GROUP BY Intervensions1.Location;
 
 

If it's your record source for your report then if you change the query just slightly so that your parameter will show up in your field list for your report, like so:

PARAMETERS [Enter Pharmacist Name] Text ( 255 ), [Start Date] DateTime, [End Date] DateTime;
SELECT Intervensions1.Location, Count(Intervensions1.fldID) AS CountOffldID, [Enter Pharmacist Name] AS NamePrompt
FROM Intervensions1
WHERE (((Intervensions1.Pharmacist) Like "*" & [Enter Pharmacist Name] & "*") AND ((Intervensions1.Date) Between [Start Date] And [End Date]))
GROUP BY Intervensions1.Location;

Then you should be able to put this expression in your textbox on your report:
="Interventions by location by " & [NamePrompt]

As I mentioned before, this method has worked for me in the past, but the way I've used it in the past, I've needed my prompt to be in my field list.