Recent content by irishcavan

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...

I have one other question for you, Bob... lol... probably an easy one too.. but i am still playing around with the changes and adds of Access 2007. I have a main category and a sub category. I am currently using Combo Boxes to select the correct categories. However, what I have not set up...

Thanks for the reply, Bob. I am thinking that maybe I should go back to bed and wake up again. That is what I did the first time. The problem was that the field window was not long enough in the form.. so it was showing "#####"... lol... I guess it helps when the field window is the correct...

: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...

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...

Hey, Sammy. I got it.. I needed to replace ROUNDUP with INT, Old Expression: Sum(roundup((IIf([WHITE PRICE]<10,[WHITE PRICE]*4,[WHITE PRICE]*2)),-0.01)-0.05) New Expression: (Int(IIf([WHITE PRICE]<10,[WHITE PRICE]*4,[WHITE PRICE]*2))+1)-0.05 Thanks for all your help Sammy. Irish :D :D

Hey, Sammy. Yes.. I tried the remaining part of the expression and "ROUNDUP" is not recognized by Access.. I am trying to find the function that I need to placed "ROUNDUP". Once I can replace that part, I can finish the expression. Thanks, Irish

Also, since you are being a wonderful help.. I would like to be able to actually use this formula in my form. Example: I enter in a record, put in the whsl price and it automatically calculates what the retail price would be and stores it in my table. Sorry for such basic questions. It has...

Sorry, Sammy... the question was about incorporating the remaining part of the calculation into the expression. Basically: Whsl Price: $9.95 Retail Price: $39.95 (right now my total shows $39.80) Orange being the current expression: Sum(roundup((IIf([WHITE PRICE]<10,[WHITE PRICE]*4,[WHITE...

Thanks, Sammy, that worked. One last question. The final 2 steps I took in calculating the Retail Price was SUM(ROUNDUP([RETAIL PRICE],-0.1)-0.05). Thanks, Irish

Sammy, thanks for the advice. However, (cry, cry)... I tried it with and without the "=", and both times i still get the error msg: "You tried to execute a query that does not include the specified expression 'v_categories_name_1' as part of an aggregate function. (same msg as before)...

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...

I am just going to use the BMP files. I got those to work fine. However, how do i make the pic larger, than it is, on the form. Right now the pic is showing the same size as if an icon was loaded up. Thanks, Irish

RuralGuy... that didnt help... any other ideas? I have OLE Object set as the data type in my table, and I inserted a Bound Object Frame in the Form. However, when I go to insert the image (ie. 1506.jpg), all the displays is jpg icon and the image name where I need the image to display. Thanks.

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...