Search results

I have a value of -£20 showing on a payment report but this won't make any sense to a customer when they receive it. Is there any formula or expressions (not VBA) on how to change this to £20.

Is there a way to display the current month using the MonthName fucntion instead of typing in the number.

I have the following query (see image) All I wish to do is copy the customerCreditLevel to the customerLastMonthsCreditLevel. What criteria do I need to this. This is all I would like to do.

I have an update query, that for some reason only updates some data and not others. Any explanation as to why this may be

I have a report that shows payments a customer made for a certain month. I would like all the payments to be totalled up for one customer. However when I generate the report it is showing each payment separately for the same customer. Please see image. Is there an easy way to fix this.

I have a customer form that contains data from tblCustomer, I also have a subform in my main form called sfrmCPartner (containig data from tblCPartner). When I run a query to search for a customer, the data from tblCustomer returns fine, but the data from the subform just returns the first...

Hello please have a look at this image: When the checkbox is clicked I would like to make the trading address info (in business details) appear in the account address info. Does anyone know any VBA to do this?

Can I run two parameter queries on report and if so how? Basically I've created a report showing customer payments for a specific month. First query is to enter the month (I have this one done) Secondly I want to show a specific customer's payments for the enetered month (don't have...

I have created a report showing a list of all payments a customer has made that month. I have created a query to search for the month and return the payments, although it is returning the payments for every customer. Is there a way I can just show all the payments for one specific customer...

Okay so i'm pretty new to VBA and I've been trying for hours to get this calculation to work I simply want to the net amount number when multiplied with the ceiling price (the prices are in the subform in the bottom right of that image) to show the total in the unit price column. I've tried...

I'm trying to do a calculation but when I try to click of the line of code, I get an an error saying Compile error expected end of statement. What does this mean? This is the code: Forms![sbfrmOrderLine]![orderLineTotal] = Forms![sbfrmOrderLine][orderLineAmount] *...

I'm kinda new to VBA and all I want to do is multiply the quantity by the agreed price and get the total to appear in the total box below the sub form.

Okay so this will be kinda hard to explain but I'll try anyway. I am making a form for my customers to order products and on it they need their own address and their shipping address i.e the address they want to their products to be delivered from. Their owen address is stored on tblCustomer...

Hi I have an invoice table which shows the date (Short Date) of the month the invoice was made I have created a query using the month function so when I search I enter 1 to 12 for the corresponding month and this should return the invoices for that month but the problem is nothing gets...