Search results

It's working for me now - when all I have to do is enter a base number. I can easily link that number and it's cost to each container. But when the new system kicks in and each container will need a base number and secondary number; and the cost is dependent on both of those numbers together...

The only thing changing is how we assign a cost to each container. Instead of one charge number, it now will require two. When I separated the two cost numbers and created a linked table between them, isn't that normalizing the data properly?

Oh. I don't have different cost tables. I built the cost into the three tables I have.

Yes, one base number can have many secondary numbers. The secondary numbers can be used for many base numbers. Unfortunately, they haven't finalized all of the costs so I don't have the numbers for each unique combination of base and secondary numbers. Is my current table structure okay?

Hmm. We get containers of products. We take those containers and we ship them. Each container costs us a certain amount of money - according to a particular charge number. Currently, it's just one number. This one number can be used on multiple types of containers of any size. I store...

Our facility takes in containers of waste and then we take those and ship them out for disposal; so it's essentially an inventory database. I have a master table of each item we get (and subsequently send out for disposal). In this master table is ClinIDFK; where I record which CLIN number...

Clin Table Data screenshot: This is my table of CLIN numbers; they are basically charge numbers. The numbers under Contract 1 (ClinContractID) are the total charge number; there is no suffix. The numbers under Contract 2 are the 'base' and there is a table of suffixes. Every CLIN will not use...

Yep. I've used this method to create concatenated queries.

Hey, this worked like a champ. Took me a while to figure out the logic in my query but after I did, I was able to get it all buttoned up. Thanks a million. SELECT tblManifestData.manifestnum AS [Manifest Num], CurrentCY.accumulationstartdate AS ASD, CurrentCY.Pounds...

Tried this and it didn't work, but the solution provided by Galaxiom works. Took some fiddling for me to get the logic right, though.

Hmm, okay. I guess I didn't thoroughly think through my process. This will be used for a one-time data verification. If I still use this datasheet to go through and add values through the combo boxes, it should still update the correct record with the data right? It just won't show...

I have a set of cascading combo boxes. When a value is selected in Cat 1 ID, it narrows down the selections in Cat 2 ID which narrows down the selections in Cat 3 ID. However, the values don't show up for columns Cat 2 ID or Cat 3 ID until I enter the row. Then I have it set to requery the...

I've been messing with this all day and can't figure this out. I am using the Multi Search from that's available in the template forum, and currently it's working perfectly. I am trying to add one checkbox (chkIncludeManifests) to the form to do some filtering. When the box is checked, I...

I have not considered that - my coding skills are fairly weak. Also, I attached a copy of the relevant part of the label making process. It starts with form frmManifestFolderLabels. It might be easier to see what I'm talking about?

I set the 'can shrink' property to NO for all parts of my report and it didn't change the output.

Doo dee doo. Anyone?

I currently have a set of labels that works flawlessly - it has 2 columns and 20 rows. I have a form that I can select which label to start printing on so I use up a full sheet with no waste. [working labels attachment] The labels I'm trying to print on now are 1.25" x 10", as seen HERE...

Thanks for the assistance. I'll try this tomorrow at work. There is only one form that this calculated data will get computed, and it's a static event, after the first computation. It's easier for my beginning mind to use the field in the database when I need it rather than create the...

Firstly, I realize that I shouldn't normally record calculated figures into my table. I'm willing to buck proper procedure here for ease of use for referencing in reports; also, it's just one data point that will be calculated only once and not changed. Anyhow, I have an IIF statement that...

I usually spend a day researching and trying things, then if I can't figure it out, I post here. This place is amazingly invaluable!!