Recent content by bcmind

  1. B

    PSA: Don't buy speakers out of a White Van / other vehicle

    you shoulda post this thread 11 years ago... u know what i mean? :(
  2. B

    Help on watching cable on LCD

    ok, i just tried to use the component inputs and it works fine :) but why doesn't the DVI works? just wondering...
  3. B

    Help on watching cable on LCD

    I'll look into the model # tonite when i get back... Also, i'll try the component input... Keep you guys update.. thanks for all that replied. :)
  4. B

    Help on watching cable on LCD

    I have a Dell 24" wide screen monitor (NOT LCD-TV) and it's connected to the cable box's DVI out #2 is the DVI on the monitor and I did switch it to #2... and I get no picture from the screen... Please help... Do I need to connect the DVI to Computer then to the LCD? Can I just connect...
  5. B

    Please help with MS Access

    just to refresh everyone's mind... this works w/o calculating the "Percent" I just need the Percent to work.. SELECT LauraAllClassAMT1.RepNum, Sum(LauraAllClassAMT1![SumOfSales Amount]) AS [TOTAL SALES Amount], Sum(LauraAllClassAMT1![SumOfCost Amount]) AS [TOTAL COST]...
  6. B

    Please help with MS Access

    everything is on the same table... no other table is involved... do I still need a Primary Key?
  7. B

    Please help with MS Access

    no go :(
  8. B

    Please help with MS Access

    Format((([SUMOFSALES AMOUNT]-(lf(([SUMOFCOST AMOUNT] is null, 0, [SUMOFCOST AMOUNT])))/[SUMOFSALES AMOUNT], "PERCENT") AS [PROFIT MARGIN] no go :(
  9. B

    Please help with MS Access

    Format((([SUMOFSALES AMOUNT]-(lf(([SUMOFCOST AMOUNT] is null, 0, [SUMOFCOST AMOUNT])))/[SUMOFSALES AMOUNT]^100, "PERCENT") AS [PROFIT MARGIN] no go :(
  10. B

    Please help with MS Access

    no... this is actually a real work question...
  11. B

    Please help with MS Access

    OK.... problem with synthax.... SELECT PCSLS.Class, PCSLS.RepNum, Sum(PCSLS.[Sales Amount]) AS [SumOfSales Amount], Sum(PCSLS.[Cost Amount]) AS [SumOfCost Amount], PCSLS.Profit, Format((([SUMOFSALES AMOUNT]-(lf(([SUMOFCOST AMOUNT] is null, 0, [SUMOFCOST AMOUNT])))/[SUMOFSALES AMOUNT]^100...
  12. B

    Please help with MS Access

    I'm sorry... i'm kinda new to this... can you explain it in more detail?
  13. B

    Please help with MS Access

    You are the best!
  14. B

    Please help with MS Access

    LdiZak, Thank you for your reply... and it works great... but now on the the next step... I want this result: Rep Total Sales Total Cost 10 $16 $8 39 $19 $7 Total Sales is coming from AC + QS (Total Sales) Total Cost is coming from...
  15. B

    Please help with MS Access

    I have a Table: Class Rep Sales Cost AC 10 $5 $2 AC 39 $5 $2 AC 10 $6 $3 AC 39 $10 $3 QS 10 $2 $1 QS 39 $2 $1 QS 39 $2...