Recent content by liutofsik

This problem is happening because I deleted the field from my table.

I had two fields in my table which I previously used in the form. I deleted the fields from the form itself but the fields are still listed under Field List and not even under any table... Delete buttons doesn't work on it, and neither does backspace? How do I remove it? Right click only gives...

A query is what I'm trying to make. Let me rephrase it a little. If I make a query with every stop I will be multiplying all my data. I feel it would be pointless to do that when my LoadStopT is already neatly organized according to LoadID_FK and StopOrder. query should look like this: |...

This doesn't work either.. firststop: DLookUp("[StopCity]&', '& [StopState] &' '& [StopZipCode]","StopT","[StopID]= ' " & [StopID_FK] & " ' And " & [LoadStopT]![StopOrder]=' " & "1" & " ') I'm so lost and I don't understand why this doesn't work?

Came across that thread and unfortunately it doesn't help. I need to look for location info from one table, StopT, and the StopOrder from a different table, LoadStopT. Bobadopolis's DlookUp criteria was for the same table.

I was under the impression the LastStop field would need to be something like this: laststop: DLookUp("[StopCity]&', '& [StopState] &' '& [StopZipCode]","StopT","[StopID]=" & DLookUp("[StopID_FK]","LoadStopT","[StopOrder]=" & DMax("[StopOrder]","LoadStopT","[LoadID_FK]=" & [LoadID]))) but it...

So many smart people here, I love it! Hello! My name is Sarunas. Taking on a project to create some efficiency for myself. Transitioning from Excel to Access will be a great leap for operations tracking for my dad's trucking company. I am from Chicago and I would love to get this access...

Hello and thanks for taking a look, Riddle you this, I will. :banghead: Trying to migrate from Excel to Access to track Trucking Operations. Building a query for a datasheet form down the road. It is meant to be a dashboard DS to show minimal information. Simplified, these tables are in the...