Name & Date by Default

[smarty84handsome]

How do i create default date and default name on report header ?

[June7]

You want current date? Textbox with expression in ControlSource: =Date()

What do you mean by default name? Could have a Label control with a name as the caption.

Give more info about what you are trying to do.

[smarty84handsome]

I have created a query with fields emp_id, entry date, Description with parameter emp_name. Now i want to create a report based on this query in such a way that on the page header part date and name of that employee should be displayed. I have already figured out how to display the date along with time but the name on the header how do i do this ?

[June7]

You have an input parameter prompt in the query under a field called Description? I never use input parameter prompts in queries - cannot validate the input, also can't refer to the input anywhere else. The query has an emp_id so there must be a table with employee names as well as the emp_id. Include that table in query by joining on the emp_id fields. This will make the name info available for display on the report.

[smarty84handsome]

I apologise in advance for providing partial information. Yes i do have another table with name employee_file and i have included that table in my query but how to display emp_name in page header every time i run a report ?

[June7]

Report header or page header?

Maybe use a textbox with ControlSource set to the employee name field.

[smarty84handsome]

Report header or page header?

Maybe use a textbox with ControlSource set to the employee name field.

Report Header

[June7]

Did you try a textbox there?

[smarty84handsome]

i am about to do it

[smarty84handsome]

okay i just tried using text box with control source set to employee_name field but it's working as just a parameter the way i want is to set report header in such a way that when i run report for particular employee his/her name should display automatically at the top in report header.

[June7]

If it is prompting for input then the report is not finding that field name as part of its RecordSource. If you have included that table in the report's RecordSource, make sure that field has been included in the field selections in the query grid.

[smarty84handsome]

So i need to add this field in query is that what it is ? coz i am still trying to link emp_file table which contains employee name and employee number but some reason it still says error

[smarty84handsome]

okay i just figured out how to do it thanks for your help it's working the way i wanted thnks for your help.