Hi. I have a qty field and a pack size field. I need to be able to round the qty field to the nearest multiple of the pack size field. How do I go about that?
Any help would be appreciated!
Thanks,
Kim
I have a field that has been encrypted and it's in a table that I have in Access. I have no idea what method was used to encrypt the data. There are no special characters used, it's just a simple key. For example, In the encrypted text, a "3" needs to become a "1" when...
Never Mind! I just realized in the one particular query where I was having that problem, I was missing the part of the syntax where t2.ndc = t1.ndc.
Sorry about that.
Thank you, it seems to work great!
Kim
Swampboogie - This code seemed to work pretty good. Thank you. I'm just running into one problem and I'm not sure if it's because of the syntax or something else. I hope you can help me figure this out.
It appears that when one NDC has multiple quantities that cannot be found in table 2...
I'm trying to find records that for a certain NDC, their quantities do not equal what is on another table. So, for table1, I could have:
NDC Qty
123456789 1
123456789 6
123456789 12
I'm linking to table2 on NDC and table 2 could have:
NDC Qty...
Thank you. This looks much better than what I have.
What about if they are not whole integers. For example, the packsize is 1.5 and the qty is 3. It's coming up as not a multiple, but really it is. Is there a way around this?
Kim
How can I go about determining if two fields are multiples of eachother?
For now, I'm trying to create two calculated fields. Calculated Field1 is qty/packsize and Calculated Field2 is packsize/qty. My thought was that if both of the calculated fields contained a number with a decimal, then...
Thank you for all of this great sample code. This looks like it would really work for what I need it to do. The only other question I have is what will it do or what do I need to do when one of the files it is going to export is larger than Excel can handle. For example, I know that one of...
I was wondering if there is an easy/automated way to export a group of records out of an Access table based on criteria of a certain field? I have a table that has 5,053,349 records in it and I need to create mini files that can be exported into Excel. The groupings of the mini files need to be...
The only problem with the temp table is there would be 128,000,000 records for each month because each of the 17 tables has anywhere from 1 million to possibly 20 million records.
Kim
I have 17 tables that are fairly large (8 - 12 million records each) for each month of data. Each table contains the same exact field names and data types. I need to find where there are duplicates across the 17 tables (and even within each table) based on three fields: Nabp, RxNbr and...
I have the following line and I would like to sum on "scripts" but it keeps telling me that "scripts" is not a valid column name. Any suggestions?
Scripts = case PaymentTypeId when '3' then p.tpm when '2' then p.tpm when '1' then p.cash else 1 end
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.