Search results

  1. M

    SetAttr vbarchive

    Hi- I'm using a function to find all files/folders in a specific directory, then copy each one to a specific destination folder. I'm going to use this on a weekly basis to backup files on a computer. I would like to use the vbarchive in GetAttr/SetAttr so I only need to copy these if they have...
  2. M

    complex dlookup?

    Hi- I have products listed below: item shipdim1 shipdim2 shipdim3 ITEM10 28 28 11 ITEM11 13 11 2 ITEM12 32 21 18 ITEM13 30 96 57 ITEM14 30 72 57 ITEM15 30 60 57 ITEM16 28 28 11 ITEM17 44 15 12 ITEM18 25 8 7 ITEM19 37 8 7 ITEM20 25 8 7 ITEM21 47...
  3. M

    SQL Enter parameter value problem?

    Hi- have been working on this for hours and cannot find the problem: I'm trying to insert a text value into a table (from another table). I need to insert the text value, then I will insert other code to email a report (not shown here), and then loop to do the same thing until the end of...
  4. M

    Hard problem - loop until?

    Hi- No idea how to solve this one.... I work for a distribution center and I'm trying to create code to calculate, given known dimensions of our products and qty's, the number of pallets needed to fill each order. Here are the relevant fields: skuid percentpallet: the percentage of a...
  5. M

    swap columns and rows

    Hi- I need to switch columns and rows. here's what I currently have: loc, shift, dep, mc, disc, amex 40, 1, 100, 200, 300, 400 40, 2, 150, 250, 50, 20 40, 3, 50, 25, 60, 100 41, 1, 500, 300, 600, 400 41, 2, 175, 20, 50, 200 ect.. Here's...
  6. M

    missing one sql line?

    I'm not sure how to explain (and therefore search) this so forgive me if this has already been answered. Here is my current table (I've changed the field names to make it easier): Date Deposit 4-5-11 $1000 4-5-11 $2000 4-5-11 $500 4-6-11 $200 4-6-11 $100 how can I modify the results to show...
  7. M

    Running Totals

    Hi- I'm trying to create a running totals in a query and am stumped. I've read similar posts and cannot understand why this is not working for me. I have a table named "test" with the following info: testid (autonumber) AQty 1 30 2...
Back
Top Bottom