Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

need help with Query SQL WHERE syntax

qryTripSectors returns some fields from the previous record for use on form "Trips". Each record in the table "TripSectors" has a TripLogID

I only want to return fields from the previous record WHERE TripLogID's are the same, I cannot fathom the correct use of the WHERE function in the query SQL.

C:\fakepath\BaseVanTripsVer7.5.odb

Cheers

Mike

need help with Query SQL WHERE syntax

qryTripSectors returns some fields from the previous record for use on form "Trips". Each record in the table "TripSectors" has a TripLogID

I only want to return fields from the previous record WHERE TripLogID's are the same, I cannot fathom the correct use of the WHERE function in the query SQL.

C:\fakepath\BaseVanTripsVer7.5.odb

Cheers

Mike

image description

Pic of the form "Trips" With depart details from the previous Trip (TripLog1)

need help with Query SQL WHERE syntax

qryTripSectors returns some fields from the previous record for use on form "Trips". Each record in the table "TripSectors" has a TripLogID

I only want to return fields from the previous record WHERE TripLogID's are the same, I cannot fathom the correct use of the WHERE function in the query SQL.

C:\fakepath\BaseVanTripsVer7.5.odb

Cheers

Mike

image description

Pic of the form "Trips" With depart details from the previous Trip (TripLog1)(TripLog0)

need help with Query SQL WHERE syntax

qryTripSectors returns some fields from the previous record for use on form "Trips". Each record in the table "TripSectors" has a TripLogID

I only want to return fields from the previous record WHERE TripLogID's are the same, I cannot fathom the correct use of the WHERE function in the query SQL.

C:\fakepath\BaseVanTripsVer7.5.odb

Modified DB:

C:\fakepath\BaseVanTripsVer7.5.odb Cheers

Mike

image description

Pic of the form "Trips" With depart details from the previous Trip (TripLog0)