Search results

hi I have the DSum expression as below: Balance_Customer: Val(DSum("([Amount_Cash_Customer]","Orders","Customer_ID = " & [Customers].[Customer_ID] & " and Order_Date <= #" & [Order_Date] & "#")) but it is not calculating accurateley and there are differences in results, when Order ID in not in...

hi combobox not working on the form. The attached Db has a form customers. I cant enter anything. Any help plz !

hi I have a form named frm line total net. in its source query design , when i link the table suppliers, the fields in the form disappear as shown. where is the problem. plz help.

HI i have a form in my db called All Customer Orders. On it , there is a combo box named Customer_ID. In this form, there is a sub form named frm line total sale3. I want that if combo box named Customer_ID , one value is selected on this main form, then the combo box named Customer_ID in the...

hi ,when append query, C-Add, is invoked, it should calculate Amount_Sale present on Form Main respective to the customer, but thats not i am getting. it gets without discount. i tried to set it but in vain. that can be checked in customer orders by customer report any help

hii have attached a db. in all customer orders form, i want that whenever Rate is inserted and toatal i s automatically calculated, then the field Net_Amount_Cus ,s value be automatically inserted into the Amount_Sale filed. means query C_Add_Amount should run automatically. how would i do that

hi, I have aform in my attached DB , named ''All Office And Labor Expences''. There is an append query called C-Add to append certain data from the table Labor_Expenses to the table Transport_Expenses. but its not working and giving the error messeage, it can't append all the records in...

hi how can I select all the checkboxes with say a button, What should I do? i have attached file. plz help

When I select multiple rows I want my delete button in the form to delete all the records I have selected. It just ends up deleting the row selected at first. That doesn't choose all the selected entries. Any way to select all rows and delete in a single step. SQL is as: SELECT [Line...

hi, I ahve a simple query: I want that the order ID 144 and 145 should show only , with 1000 and 400 amount and the last 2 columns with null values to be dropped. It should show as the SQL is SELECT Orders.Order_ID, Orders.Order_Date, Orders.Amount_Cash_Customer, Orders.Amount_Cash_Supplier...

How should I have a result that shows only the records NOT already in the table I want to append to ? The SQL code is as follows: INSERT INTO Orders ( Product_ID, Customer_ID, Order_Date, quantity, Unit_Price_Sale, Amount_Sale ) SELECT DISTINCTROW tblorderproduct.Product_ID...

hi, I have a database attatched with from name 'Main' , and when I run append query named 'C-Add' from the form through clicking button 'Process' then,,, the query appends the previous order's enteries also. i.e they are copied teach time. how can i prevent this. plz help. urgent

hello