Recent content by swamprat96

having a play with this now- thanks!

Ah- totally misunderstood DSum- thanks!. I thought the syntax was too simple- now I get it Cheers Tony

I haven't been near Access for about 5 years so go easy. Trying to recall it all I read http://support.microsoft.com/kb/290136 - which uses DSum for a running total. Their example was much more complicated than I need so I was trying to understand how the thing worked. I have searched the...

Hi paul, Sounds good- I'll have a play in the morning

Have a look at the attached test.db. I'm trying to make a running total in the Query- but I'm obvioulsy making a basic mistake. Can someone point me in the right direction? Cheers Tony

Nearly there. I'm trying to use Dsum to make a running total of the field "Rounded Count" by "Category" in the following Query code - but its giving me weird numbers that don't make sense. Any obvious mistake here? SELECT Qpagenumber1.[Category Field], Qpagenumber1.[Rounded count]...

I just had a quick and dirty idea There are a maximum of 8 records per page. I can write a query to work out how many items are in each category. The report displays by category alphabetically so I know what category comes after each one The first category has 13 records. This means that I...

yep I gathered that- thanks. Reading the microsoft docs now but looks tough

No- I mean a one page report that says Accessories- Page1 Ball sets - Page 5 Trees - Page 10 and so on. So I need to pick up the starting page for each category so that I can create a Table of contents for want of a better description Cheers Tony

Last task for the day- if possible. I've never done this before for a report I have an item report that now page breaks by category thanks to this forum. If possible I'd like to generate an index by category for the report. It can be a separate report. I tried the microsoft suggestion but...

Thanks - saved me hours of head scratching

I have a report that sorts products by category. I want to force a page break when the category changes. The category field is just a text field. I realise that I need to use the Visible property of Page break on an event but I can't remember/work out how to write an event that recognises a...