Search results for query: *

Great Thanks a million. Have a great day Craig :-D

Hello all you Excel masterminds. Stumping problem giving me a headache, and they say a problem shared is a problem halfed so here it is. I have a form in excel. Into this form I would like to place either a subform or frame (or what ever). The subform is about an A4 page long, and the space...

Cool. Brillant off to play with this very helpful function. Have a star. Craig

Hi Ladies and Gents, I'm have a little style problem, and hope you can sort me out. I have a PDF with a date field, I'm filling that field with data from FDF. The text field for the date reads 20122003 However to fill the boxes in the right places the date has to read 2 0 1 2 2 0 0...

Hi smithBr, As it's 23:56 in the UK. I could be in need of sleep. But to try and help, but here goes. Commissionable Total: [Balance]-Nz([DeductionAllowed],0) Not to sure of how you can fit this into your code. But the Nz function will replace Null with 0 so as your calc works.

mpastore Mike, You are the Man!!! Hooooooray :-) I could run around the room with delight. Thanks for the timely, helpful and brillant post. The query is working on the database. Thanks Have a star Craig [2thumbsup]

SELECT SUM(Field14) AS Amount, 1 AS [Band ID] FROM orders WHERE (((Field14) Between 0.00 And 9999.99)) UNION SELECT SUM(Field14) AS Amount, 2 AS [Band ID] FROM orders WHERE (((Field14) Between 10000 And 39999.99)) UNION SELECT SUM(Field14) AS Amount, 3 AS [Band ID] FROM orders WHERE...