Search results

  1. I

    Calculating Pricing

    I have a math problem for you. I have tried to write the code a couple of times, but to no avail. Here are the details: Item 1: $ 02.65 - mark up 150% Item 2: $ 15.85 - mark up 75% Item 3: $ 62.58 - mark up 25% Final Dollar figures need to be rounded up to $ xx.95 I have the calculations...
  2. I

    Date Record Added

    :confused: I am trying to add a "now" field to my table and records. I currently have 2234 records in my table (old records) and I would like to be able to query only new records, or records within a date perameter. I have tried the "Now()" function but I am getting an error in the field when...
  3. I

    2 Combo Boxes

    I am trying to set up 2 combo boxes in my form. The first one holds the Category and the second on holds the Sub Category. I would like the second combo to only pull Sub Categories pertaining to the Category selected. I have the Category fields set as: CATID, CATEGORY I have the SubCategory...
  4. I

    IIF Expression

    I am trying to execute a query that calculates a retail pricing off the whsl pricing. This is the excel calculation i use: =IF(F2<10,(SUM(F2*4)),(SUM(F2*2))). I changed the IF to IIF, and replaced "F2" with "[WHSL PRICE]. However, I am getting an error that the "category" expression is not...
  5. I

    OLE Bound Ojects in MS Access 2000

    Okay, I have read some of the other threads and I am not really able to follow what needs to be done. I have a file of product images located on my harddrive, and I would like to have the images displayed in their respective record. However, the image only displays an icon stating the image...
Back
Top Bottom