Search results for query: *

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

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

I have a calculated control in a subform. I want to display the results of that calculated control in another form (not the main form). Is there anyway I could possibly do this? Help.

I am having trouble trying to link another form and its specific record through a button control in a subform. My dilema is mapped below. Form 1 - Location Subform - link for Part Number and location Form 2 -Part Number The push button is located in the subform of Form 1. When i select the...

I have a form that is based off information from another form. i want to create a button on the bottom of the one form, so that when i click it, it will bring up the other form with the information from the other form according to the record that im viewing on the first form. Please help...

I have 2 tables that are unrelated. Table 1 - Address Location / Address / City / State AA 1234 Denver CO BB 5678...

I have 2 tables that are unrelated. Table 1 - Address Location / Address / City / State AA 1234 Denver CO BB 5678 Chicago ILL Table 2 - Route Stop 1 / Stop 2 / Stop 3 / Dist in...