Help with dlookup

[Clueles]

I’m trying to use multiple criteria and I can’t get the syntax right for the life of me. I have no training but have managed to create a decent database.

I want to fill in a field on a form called waa based on the value on my hours tally table.
=dlookup([total hours],[hours tally], [hours tally].[rep]=1 and forms!waa!queuedate = [hours tally].[date worked]

 

[The_Doc_Man]

Probably should include the forms reference using square brackets around each component like you did for [hours talley].[rep]

Also, your parentheses are unbalanced. You need a closing parenthesis after the [Date Worked] element.

 

[isladogs]

You also need :
a) quotes around each part of the expression
b) date delimiters (#) for date field
c) final bracket as already mentioned

=DLookup("[total hours]","[hours tally]", "[hours tally].[rep]=1 AND Forms!waa!queuedate  = #" & [hours tally].[date worked] & "#")

Lots of help available online. For example, see http://access.mvps.org/access/general/gen0018.htm and http://allenbrowne.com/casu-07.html

 

[June7]

Shouldn't the reference to form control/field be concatenated instead of the table field?

=DLookup("[total hours]", "[hours tally]", "[rep]=1 AND [date worked] = #" & Forms!waa!queuedate & "#")

 

[isladogs]

June

Oops. Looks like in fixing other issues I also missed something.
Yes I agree with your new version.