Search results

Ok, I have a form that lets someone enter Toll Receipts. The Form has a couple of fields, one being a combo box that looks up 10 toll types in another table, and about 4 other data entries such as date, time, amount, and the the toll number. This is all sent back to the same table, the "Toll...

If you have a query that has order id as one field and totalprice as another field, can the query assign the totalprice a 0 value if for an order id there was no totalprice entered. See if you don't enter a totalprice, yet you want to pull another total for let's say maintanence in the same...

Totaling I am working on a report that does totals of every order ID for s date range. The only problem is that on some orders, some items are not ordered. See, each item is attached to a code. 1 is for parts, 2 is for labor, 3 is for tires, ect all the way to 6. When you enter stuff in the...

Didn't Work The nz function doesn't seem to work. Is there anything else i can do, like and IIf function or something. I just need something that can go in the criteria of a field within a query, and tell the query that if it a null value, that means if there is nothing there, give it this...

Is there anyway to do this: Let's say I have a combo Box, looking up values in a products table. Values like Product name and such. Is there anyway to send back into the table not only the choice you selected on from the combo box, but sending back 0 values of all the products you didn't select...

Too Complex I might have made it very confusing. All I need is to assign a 0.00 to a null value in a query. When a query comes upon a null value all I need is it to say hey, there is a null value, I'll put in a 0.00

I have a qeury that is pulling totals for a report. It needs to pull six totals, and then show the totals for each Order ID#. So it should say order Id #1, then six totals, even if the total is 0.00. Each type of service is coded, so code#1 is a tires repair, code#2 is a fluids repair, ect...

I have an order entry system I am designing for a client. There is and order ID number associated with every product that is ordered. So they can have multiple products with the same order ID #. Also labor orders can be ordered on that same order form, and these too are given the same ID #. So...

I have designed a form with an option group and two check boxes within this option group. The first box is checked by default, and when this is checked some boxes in the form are locked, it doesn't let you enter data, but if you check the other box, these boxes open up, and others lock so you...

Has anyone ever seen in some programs, where the developer has a splash screen, where you strike several keys at the same time, and a screen pops up that says created by _____, and ect. Does anyone know how to accomplish this in access?

I have been working on this database for a trucking company for some time now. When I first started all their Drivers were done through Social Security Number, but that got tedious, so i made a query to lookup driver SSN, then come back with the actual driver name. I am now working on a report...