Can't get my formula to work

[punter]

Hi,

I have a formula that I think should be working but isn't.

=[BOL Date]+(qryTransitDays!TransitTime)

I want to Add the BOL Date with the Transit Time from the Transit Days query. It is giving me a return of #Name?. Any thoughts on why?

Thank you so much for you help.

Eddie.

 

[Dreamweaver]

=[BOL Date]+Dlookup("TransitTime","qryTransitDays")

That will lookup the value in the query I haven't added any limiting factors for your Query

Mick

 

[punter]

Thank you so much for your quick reply.

I put the copied the formula and put it but it doesn't seem to be working. It returing a blank which is an improvement over the #Name? I was getting before.

Is there something else I should be trying?

Thanks

Eddie.

 

[Dreamweaver]

Can you post a copie your db so I can sort it for ya.

You'll need to zip


Mick

 

[punter]

I didn't have a chance yesterday to attached the zip file. I have now.

The form in question is named BOL_information_entry. The field with the formula is named ETA date. It seems like it should be working but it doesn't. Any thoughts on what I'm doing wrong are most welcome.

I had to strip a lot of stuff out of the original database in order to get it a size where I could attach it here. This isn't the finished the product. There might be some warnings about missing relationships or something but ignore them.

Thank you all so much for you time.

Eddie.

 

[boblarson]

Change your formula to:

=[BOL Date]+DLookUp("[TransitTime]","tblTransitDays","[PortofOrigin]='" & Forms!BOL_information_entry![Port of Origin] & "' AND [PortofEntry]='" & Forms!BOL_information_entry![Port of Entry] & "'")

 

[punter]

Bob = the man!!!!! I was wayyyyyyyyyyyyyyyyyy off. Your formula works great. Plus, I can take it apart and figure out why it works.

Thanks again Bob.