Dlookup in access report

Hi all,

I'm dealing with this crazy database at work and I have no idea how to solve this problem:

One of the reports required is a weekly forecast. Inside the report I created several boxes to show the week end dates using these commands =DateAdd("d",0,[Enter Starting Month dd/mm/yy]) , =DateAdd("d",7,[Enter Starting Month dd/mm/yy]), =DateAdd("d",14,[Enter Starting Month dd/mm/yy]), etc until =DateAdd("d",357,[Enter Starting Month dd/mm/yy]).

What I'd like to do is lookup the date inserted in order to show the number of working hours for a week.

In a table called "weekly calendar" I stored some data in this way:

Please Login or Register  to view this content.

I tried to use the below formula in the same report:
=DLookUp("wca_hours","weekly calendar","wca_weekd= #Label178#") #where Label178 is supposed to be the name of the box with =DateAdd("d",0,[Enter Starting Month dd/mm/yy]) as Control Source

In other words what I'd like to achieve is: If the user insert "20/01/2017" the report should show 36

Well... it doesn't work LOL. I get a #Error message!

I'm not good with Access at all and I just thought that perhaps there is a good soul in this forum able to help me :-D

Thanks all!!

Hi,

Try this

=DLookUp("wca_hours","weekly calendar","wca_weekd=" & me.Label178 )

Hi guru008,
I get a #name? error. What "me." is supposed to be?

You shouldn't need Dlookup in a report.
The query should provide all data.

Hi ranman256,

I'm not good at all with Access and I thought about it. To be honest I have no idea how to achieve it though considering that this command =DateAdd("d",0,[Enter Starting Month dd/mm/yy]) force me to "insert" a date before to run the report and not in a query...