Search results

Thanks for your help :) I'll have a go at amending my structure.

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

I've now done that and also eventually found that the Has Module property was set to off on all his forms, which I'm guessing wasn't helping. Anyway, all is now fine!

Thanks for all the help everyone. I've managed to get it doing what I want now. Everything works on my system perfectly - the problem is when I sent it to the person who it's for, he keeps getting errors everytime he updates a control on a form that is using code from the AfterUpdate event. This...

Ok, if I was to do this as a query, any ideas on the best way to get the result? I would have fields from 2 tables - PurchaseContracts and Sales Orders. Both tables have a field called PurchaseContract, and everytime I enter a new order in SalesOrder I choose a PurchaseContract from a list...

I was told on another forum that doing this in a query would be the best way, but I really do need to store this in a table if possible. Any ideas on what the calculation would be?

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