Search results

Cheers Chris, Ive just had the problem again and noticed that one of the variable assigned previous to the error is not always capturing the data from the form resulting in a variable containing null. Its really strange because 99% of the time it works. If I step the code back to were the...

Occassionally I get an overflow message when sending emails out from an access app. all i am doing is taking numbers from a form and assigning them to variables then building up a message as a string then sending them out as an E-Mail. The weird thing is that I will get an overflow error, go...

Doesnt matter. Sorted it sort of. I just created a temp table with sales summed up alongside accounts and reps with the date fields cut down then ran the crosstab on the temp table. bit crappy but it works. if anyone has a better suggestion im open to offers.

SQL to see any probs. TRANSFORM Sum(([TBL_Order_Contents]![Qty]*[TBL_Order_Contents]![Price Sold])) AS spent SELECT TBL_Orders.EmployeeID, TBL_Orders.[Customer ID] FROM TBL_Orders INNER JOIN TBL_Order_Contents ON TBL_Orders.[Order Number] = TBL_Order_Contents.[Order Ref] WHERE...

I need to generate a report concerning sales. I have a table with orders in related to a table with order contents. all orders are related to salespeople. I want to work out what customers have spent over the last 3 months by salesperson so i thought of a crosstab. I used a query first of...