Search results

Thanks, I need all the luck I can get :)

That works perfectly; it's exactly what I need. I didn't realize that the solution would be as simple as this. I didn't realize that you could calculate math in an IIF string like that.

You are correct. The calculation that should be done is the following: 1. If the CLIN is priced 'per pound', it should multiply Cost Per Pound and Pounds. 2. If the CLIN is priced 'each', it should multiply Cost Per Pound and a text field with the number of items [we can use 1348Commnts...

Re-uploaded.

Okay, here's my full db. I scrubbed out a lot of data but left enough so that you should be able to see what I'm doing. I'm still pretty new to Access so I'm sure there's a lot of things that could be done better. I'm continually working on this to improve it. Thanks for your help!

Okay. I'll post it in A2003 format.

Main Form "how many containers I have": 1348Comments "Their weight": pounds Subform: subfrmInputEtid The combo box with the price list: cboClinList

I have a table with some prices that are charged by the pound and some that are charged by each. tblPrices ID 1 - 1.00 per pound ID 2 - 1.50 per pound ID 3 - 2.00 per pound ID 4 - 5.00 each ID 5 - 7.00 each My form is set up so that way I count how many containers I have and their weight...

Bumpity bump bump!

So combine both sets of data into one lookup table and delineate between the two by using contract number?

Okay. After getting more information from my boss about the new CLIN list, it looks like the new list is going to be totally new and different. I was unaware that the list was changing so drastically. So this means that I can't do a 1:1 for each CLIN line item. Before there were like 50 now...

We have a lookup table that has a list of CLIN numbers and their costs. The contract that governs those CLIN numbers and costs will be changing to entirely new numbers. Unfortunately, I still need to have the old and new CLIN numbers linked to the other tables. Will I need to merge all the...

So I got an email that someone replied to this but I don't see the reply!

Okay, here are the relevant parts of the database. I sanitized the table of data. In case you are wondering - I imported my word doc as an image file because I couldn't figure out how to take my data and export it into a word doc (which I imagine would be the better way). Edit: Totally off...

Sorry for the delay, was off of work dealing with a stolen vehicle :( Would you just like the reports we're talking about or the entire database?

I did Me.Filter = strwhere Me.FilterOn = True But got an error: procedure declaration does not match description of event or procedure having the same name.

Thanks for your patience! I think that using it as a public variable is probably easier than trying to set up OpenArgs. Guess I'm off to do more research!

Ah, I didn't know the subreport rendered first. I'll move the OpenArgs to the main report and give it a shot. If it doesn't work, then I'll have to do some searching on how to set strWhere as a public variable.

Okay, so I'm doing something wrong. I changed DoCmd.OpenReport "rptManifestLetterToState", acPreview, , "ManifestDataIDPK IN(" & strWhere & ")" to DoCmd.OpenReport "rptmanifestlettertostate", acPreview, , "ManifestDataIDPK IN(" & strWhere & ")", , "ManifestDataIDPK IN(" & strWhere & ")" for...

Thanks, Paul. I'm going to scope these out and see if I can get something implemented.