Search results

I said that's what the pounds were set to. Pounds are a weight, they can't be set to currency.

Huh. Well besides adding the tblCustomerStop with it's 2 fields of CustomerID and StopID I'm not sure at all what else I need to do. Honestly, I'm not even sure how to utilize that table since everything is set up the way I was doing it. But I'm trying to populate the new table. Right now I'm...

I have an additional table setup now to just combine customer and stop number. So if anyone has any ideas on my original question of how to set up the data entry I would love to hear them! Nothing I've tried has worked. Using tb;CustomerStop as the go between as a subform, I set it to default as...

The way the queries are set up now is to match the LoadID, StopNumber and CustomerID from the tblStopFeesDetail and tblStops. Then I either group them by LoadID only if it's to report from that side, or by CustomerID if it's from the invoicing side. The Load reports don't look at what customer...

Exactly! I just figured that criteria out today and that is when I got stuck and decided I needed some ideas. This project has been down 4 dead end paths so far so I'm not looking at it very clearly. Should step back for a day and regroup but I just need to be done! Lol. I was trying to decide...

Except for the trucks. They are owned by this company not the trucking company. They're a separate entity all together. A load can only be hauled by one truck. The tblTrucks gets updated with the new miles added on and that's reported on when they need serviced or something is expiring on them...

This is the copy I've been playing with so pay no mind to some of my "experiments", but you'll get where I'm trying to go. The data entry of the loads and the invoicing are the sole purpose of the Db. One is looked at from the load side, the other by the customer side. they aren't a very large...

Almost, trucks have nothing to do with trucking company, only drivers do. A trucking company has many drivers. A date can have many loads. A load can only have 1 truck, date, driver, trucking company, perPoundRate, Miles and Cost. A load has multiple stops. A stop can have multiple customers. A...

The cut off one is tblTrucks if you can't tell.

I don't like the way the drivers and trucking companies are set up but couldn't really figure out another way to be able to look up a driver by their Company and by the Load.

I thought I had a direction I was going then yet another criteria arose and I'm just having a hard time picturing it. I've also just been staring at it for too long. In the attached pic is what I had but now there can be more than 1 customer per stop so the subform on the right won't work. The...

The data type in the table is Currency.

Well that seems to have done it! Thank you. It probably would help if my dummy data was a little more realistic, and honestly my python faker scripts usually hit it right on the mark but I guess truck driving just isn't a learned type yet. Lol.

This is what I got using the Module.....*ugh

Yeah, that did no good at all. Still the same results.

So, I created a table with a few of the same numbers, they multiplied correctly because in the table I set them to Double and 4 decimal places. At least I'm assuming that's the difference. But in queries it doesn't give you the option to format that specifically. And in my source table I have...

I know rounding can almost always be an issue, which is why I usually don't convert values to currency until the "end" when they're being displayed or used for end use cases. But this is just glaringly odd and definitely not a rounding issue. Some of the values are off by way too much for...

Okay, below is the final working code. Thank you guys so much for the help! For anyone else using this in the future, make sure to set the value of the combobox to Null before this code runs. And set the column width to more than the 0" default so you can see it! Lol The only downside is that...

That's the question though.....how do I set the range? I need all the headers, it will always start at A1 but every file will have different numbers of columns. So the range needs to be dynamic and return the value of every cell in row 1 until it's empty.

Okay so this...… Debug.Print objWsh.Range("A1").Value DOES WORK!!! Yay!! Lol. 1 step out of the way. So now how do I get it to read all the way across row 1 until there isn't anything left? I felt like I could do something with the line "Set Rng = objWsh("A" & I).End(xlToRight).Column" but no...