Solved Access result apperance

[Springblossom]

Hello.

The final result does not show in the report queries.
Could you please help with finding out what could the problems be in these cases?

 

[theDBguy]

It might help if you could post the SQL statement for your query as well as a sample set of your data and the expected result from it.

 

[Minty]

I think we need to see your tables in design view and the relationships, as from the field names I think you have some design issues.
Year and Month are both reserved names in Access, and they should simply be displayed if required extracted from a single date field.

 

[Minty]

What is the row source for the Employee Combo box?

 

[oleronesoftwares]

Lets see the select query / row sources of the three controls.

Employeename
projectname
activitycategory

 

[Springblossom]

What is the row source for the Employee Combo box?

Row source: SELECT [Employees].[ID], [Employees].[Employee] FROM Employees;

 

[arnelgp]

=DLookup("CostCenter","Employees", "ID = " & Nz([EmployeeName], 0))

 

[Minty]

To explain - @arnelgp post
Your combo box is storing the Employee ID, not the name. This is the correct way to do this, but you then need to make sure you look up the ID - not the name.

As a bit of advice, I would change any ID field names to EmpID or similar, as if you have 10 tables with ID fields you won't know what ID you are referring to...

 

[oleronesoftwares]

I think an image of the design view of your query is needed, did you click to show a column in the query or not?

 

[Springblossom]

I think an image of the design view of your query is needed, did you click to show a column in the query or not?

Yes I did.

 

[Springblossom]

Thank you very much. I could solve it by this code:

=DLookUp("CostCenter";"Employees";"ID=" & Nz([EmployeeName]))

 

[arnelgp]

Nz([EmployeeName])

you might get unexpected result using this because you are changing it into a String.
while ID is Long integer.

 

[Springblossom]

when I enter an employee name, I have a result but if the employee is empty then it says #error.

 

[arnelgp]

that is why you need to write:

Nz([EmployeeName], 0))

 

[Springblossom]

I entered it, but it says it is too long for some reasons.

 

[arnelgp]

is this what you have?

=DLookup("CostCenter","Employees", "ID = " & Nz([EmployeeName], 0))

 

[Springblossom]

yes, it is.

 

[Springblossom]

This is the message I get when I enter that code.

 

[arnelgp]

sorry you need to use semicolon:

=DLookup("CostCenter"; "Employees"; "ID = " & Nz([EmployeeName]; 0))

 

[Springblossom]

yes, it worked. Thank you arnelgp.