Search results

Hi all I have a question about a report. This is my report as it stands. It's sorted by month, and shows the products that have been ordered that month, and the individual customer orders by each customer. These fields are pulled from a SalesOrders table. It all works exactly as it needs...

Hi all I have a form called Sales Orders which is based on a table called Sales Orders. I have the form laid out like an invoice so that when I enter data, I can just print it off before I close it. This form also updates the Sales Orders table. Usually all the records that I had entered are...

Hi all Not sure if this should be in here or in the queries section. What I want to do is produce a report from my SalesOrders table which will be formatted as an invoice which can then be printed. But I'd like to be able to select the CustomerOrderNo record I require from the SalesOrders...

Hi there. I wonder if anyone can help with a new column I need in a report. Below is a screenshot of how the report is now. What I need is a fourth column that gives a running total for each customer every month. Take for example, Sumesco food - they ordered 72 tonnes in May, and 48 tonnes...

Hi all. I'm having a slight problem with a report. I'm pulling in 5 fields from a query - InvoiceMonth, Country, NetValue, VAT and GrossValue. What I'm after is to get a listing for every month of each countrys subtotals for the NetValue, VAT and GrossValue. I have done this, which works fine...

Hi there. I have a report which is working great apart from one problem. I have ot grouping by CustomerName which is fine, then I want it to sort by NoOfDays. Now, it does this, but it treats 9 as higher than 20, for instance. It only seems to be sorting on the first digit of every number. Any...

Hi everyone I wonder if someone can help me with an IIF function in a query. I'm calculating the NoOfDays field. This field only apperars in the query and is currently calculated by the following:- NoOfDays: DateDiff("d",[InvoiceDate],[CurrentDate]) I type this into a field box in the...

Hi all - this is my first post here :) I need to calculate a field based upon two other fields, but not quite sure how to do this. The situation is I have a form based on a table called SalesOrders, and a table called PurchaseContracts. I need to work out a field called Offtake in the...