Search results

  1. P

    Problem pulling data from a specific category

    I'm trying to create a report that will only pull data from a specific category. For example, I have a Table, called "Category" and inside it has 3 items listed: "cpu", "mobo" and "ram". I also have a Table that contains more data specific to my categories, and also references those...
  2. P

    Search/Replace question.

    not sure if I can explain this correctly, but I'll give it a shot.. I have data in a cell with with either end in a "A", "B", "C", "D" or "E" for example A 1 GA08150A (or it could be GA08150B, GA08150C, GA08150D or GA08150E) the GA will always stay the same, the 08150...
  3. P

    Drop down list question..

    I have one sheet with the following info: A B C 1 Name Company Contact Number 2 3 John Company A 555-555-1234 4 Eric Company B 555-555-5555 I...
  4. P

    Sorting question..

    Hello, I'm trying to sort a column in a Report and I'm having problems. The column I want to sort is a formula, and therefor would not be listed under the Field/Expression column when sorting. I've tried adding the formula as the expression, but it would not work. Is there a way to get this...
  5. P

    Date querys

    Hello all! need some here here. I'm making a Item db where the items have expiration dates, and what I'd like to have is a report that will show items that have expired and items that will expire in 1 month. For some reason I'm stuck getting started, could anyone point me in the right...
  6. P

    Design issue with a Report

    Hello all. I have a Report that hides duplicates of a Item name, but does not hide a date associated with that Item. ie. Product Name Date used Product X 8/11/07 8/13/07 Product Y 8/10/07...
  7. P

    Auto email notification question.

    I have an inventory database, and would like to know if there was any way to have a auto email notification when a specific item in a table is out of stock, or is low in quantity? I know who to do the auto notification when a form is created or modified, but I can't seem to figure out how to...
  8. P

    Setting a negative number to 0

    Hello all, i have a calculation in a report that sometimes results in a negative number. is there anyway to make that negative number = 0 or equal to a specific text?
  9. P

    Simple calculation help

    Well, I hope this is simple, but for some strange reason, very difficult for me. I'm having issues setting up a calculation between 2 tables. for example: Table1 ID Quantity Table2 TransID Used The "Quantity" from Table1 is a set number but the...
Back
Top Bottom