Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hello,

Just add to link on sub form:

image description

Hello,

Just add to link Note: Deleted original answer. Was looking at wrong form. As comment states, waiting for further information as can't see any problem on sub form:current form specified.

image description

Hello,

Note: Deleted original answer. Was looking at wrong form. As comment states, waiting for further information as can't see any problem on current form specified.

Edit 2019-01-16:

The problem is in the ON section of the join. Only 'PrevAccom' are considered. With the multiple use of AccomodationID, the 'TripLogID' needs to be used also for uniqueness:

ON ("A"."PrevAccom" = "B"."AccommodationIDPrior") AND ("A"."TripLogID" = "B"."TripLogIDPrior")

and "TripLogIDPrior" needs to be added to the selection for "B"

As a separate note, there is what appears to be an incorrect date in Trip Log 0 - 01/03/17 depart date seems to have an incorrect year causing your calculations to be way off.