Recent content by Kingsteveiv

microsoft access does not have a round function...

Im trying to round values up using the CInt Function. However, this function rounds down if the value returned is below .5. I would like it to round up regardless of the decimal value returned. Is there a function out there to do such a thing? ex. 25/3 = 8.3333 ----> 9 thank you for any help!

I have a calculated field in my query that a sub report pulls from. For some of the records, the caluclation returns a value of zero (0). I do not want to include these records that have a value of zero (0) in my subreport. Is there anyway to filter these out? any help would truly be...

I have two tables in my database. I want to automatically compare two months that I select (most likely in a form) Table 1: Forcast Part # Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec xxx1 8 12 13 9 15 5 7 0 12 5 13 2 xxx2 5 16 13 10 0 8 15...

I have 2 columns of data ex. Column 1 5KSS3WH I want column 2 to look at column 1 and if the information in column 1 starts with a 5, place a "A" in Column 2. Is there any syntax associated with this type of action? Thanks

Dear tek-tips friends. I have a question that is a real stumper for me. I have two fields in my database 1. Customer Qty - inputted data 2. Standard Pack Size - fixed data When the customer qty is entered into the database it generates a duplicate report for each pack that needs to be...

I have another question for you. I added another field called time to the query that summed the number of containers above. I want to multiply that field to the sum of containers field. When i do this, and open up the query it returns a "Enter Parameter Value" box. If i just hit...

THANK YOU. HELPED OUT JUST PERFECT!

i have a query that has 3 fields in it. 1. part number 2. customer 3. Number of Containers I want to be able to add another field called "SUM CONT" that sums the number of containers according to the part number and customer. ex. PN Customer Num Cont SUM CONT 1...

thanks for your help, but im just going to go about everything another way. thxs again steve

I would go ahead and recalculate it, exept, its a pretty extensive calculation to ultamtly get what i want. In the form all i want to display is the name of the customer and its total. I appriciate your help and is there anyway I could do this at all?? steve

Referencing it when the other form is still open works, exept, that it only returns the value of the current form that is displayed. This is my dilema: 2 forms Form1 - Customer Totals Form2 - All Customer Totals Subform (Form2) - Customer Totals I have values that are calculated in a form...

The problem is that the calculated control is specific to a customer in the form. I would then need that control to go into another form to do another calculation, once again specific to that customer. Is it possible for me to create a calculated control on the second form that refers to...

Hello again. I have three control boxes and I add the three using the expression builder in the fourth control box. I want to put the value thats in the fourth control box into a feild in a table. Is there a code that will allow me to do this, or any other way that will allow this to happen...

Hello all! Thanks to all that have responded to my pleas for help in the past. much obliged. I have three control boxes i want to add together on my subform. 2 of the values are simple calculations (multiplying 2 control other boxes together) and the other value is a summation of values...