Search results

  1. U

    Need to Avoid Counting Duplicate Data in a Report

    Help with Counting in a report Alright, so here's the setup. Every once in a while, a truck comes to our warehouse and drops off several pallets of product. I enter these products into the computer, one line for each pallet, and also include the truck information for each pallet. The truck...
  2. U

    A coding puzzle

    I need to get an Access report to do the above, but I actually did the above in Excel. (The inventory is in Excel and is linked into Access.) I was trying to figure out what formulas I would need to get the above results, and I figured out how to get the pallet count in Excel. I can't do a...
  3. U

    A coding puzzle

    The design I can do. I'll try to give a little more detail. Well, a lot. Hold on tight. For each entry, there are three parts to the quantity: Cases (aka boxes), Packs, and Quantity per pack. So for example, if we received 3 boxes of envelopes, we might receive 3 cases with 5 packs in each...
  4. U

    A coding puzzle

    Alright, so here's a fun one to figure out. I've got an inventory file in which I determine whether a group of boxes is stacked on a pallet or not. (Anything 12 boxes or more is a pallet--anything less is loose.) If it's a pallet, we count it as One Pallet. If it's not a pallet, we count the...
  5. U

    Grouping question

    Thanks, but that's not quite what I need. I need to determine whether each receipt we get is a full pallet of items or just a few boxes of it, depending on whether the count was more than or less than 12 boxes. Then I need my report to sort them by pallets vs cases.
  6. U

    Grouping question

    I've got a report I'm working on that needs to take a list of items between two dates and determine whether it should be counted per case or by pallet. Basically, if there are more than 12 cases, it is counted as a pallet. If not, they are counted by case. I need to figure out how to sort and...
  7. U

    Sum by part

    Well the reason for the ins and outs is to keep track of the details. We receive shipments in, and we need to keep track of which trucking companies delivered how many loads on which dates. I'm unfamiliar with the +ve and -ve figures, what could I do with them, exactly?
  8. U

    Sum by part

    I'm thinking the Dsum as a source of a textbox sounds like the route I would like to go with. :)
  9. U

    Sum by part

    Thanks, but I'm not sure where should I put this. I'm still toying around with how I'm actually going to have this number displayed--I was thinking of just having an unbound text box with some kind of formula as the control source.
  10. U

    Sum by part

    I have a table in which information for an inventory is stored. There are many part numbers and different quantities received and exported for each. I have also created a form from which you can view information on each inventory entry, and what I would like to do is have a display on the form...
  11. U

    Table/Form Setup

    Excellent, this has helped out perfectly!! Thank you!! If I would have known what such a system was called, I'd have looked for it myself! ^_^
  12. U

    Table/Form Setup

    Alright, so here's my layout. I'm working on creating an inventory database with forms to enter new data and edit that data. I already have a table for the new data, and a form to enter the new data into that table. Each new entry has it's own unique ID. Now here's the tricky part. What I...
  13. U

    "Delete Record and Close" Button

    I'm trying to create a button that will delete the current record and close the form using Macros. (I'm terrible at VBA--if anybody knows a good tutorial site, please, link away!!) If I could get some help with what actions to use for the macros, I would really appreciate it!! Thank you!
  14. U

    Two Option Groups, one won't work

    I have actually figured this problem out. For anyone who might have a similar problem: Check your table. I had the first option box bound to a field with a "text" setting, and the second one bound to a field with a "yes/no" setting. Why I can't get the yes/no setting to work with option...
  15. U

    Two Option Groups, one won't work

    I'm trying to create a form for entering data for new items for a warehouse inventory. So far, I've figured everything out, but now I'm stuck. I want to create an option group for two separate snippets of information: Whether a product is damaged or not, and whether a product is in numerical...
Back
Top Bottom