Search results for query: *

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...

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...

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...

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...

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