Search results

Thanks for the link. I'll be spending some time working through it as it's quite large. I'm sure I'll learn a lot from it. Thanks!

I'm adding a sample database which is based on the actual database I am using. There are probably many things I need to get right within it but the sample records should give an accurate insight into what is going on. As always the main problem I'm trying to work out is how to get a running...

I'll make changes and put some sample data in it. I can't do this straight away because it is race day. But I'll make the changes and put it up tomorrow. I'll get back to you when I've done this. I'm very embarassed.

Hi Crystal, I've mucked this up. I forgot there was no data in it. I was waiting until I got things right but thats no excuse. I'll put some sample data in it and re post it tomorrow. That's the best I can do.

If it is any help, the RaceTime field and the Date field are going to be a composite primary key. The RaceTime field orders the data for the race, but it needs work. What can I do to help things out? Do I need to cancel my question, put some data into the database and re-post the question? I'm...

Unfortunately, I just realised there is no actual data in it. The reason being I was trying to get the design right before adding the data. The design issue is why I came to the forum to begin with. I forgot that I don't have data in it yet, but the actual design is there. I apologise for...

I have now posted the Actual database, thanks for the tip George.

There is a field in my main database called "RaceTime" which sets the order of the races. It isn't in the sample file, it is in an Excel format and not useful for this forum, but there is a field that sets the order.

Sorry, I have made a post on the original forum advising that I moved to a more relevant forum, i.e. Queries forum. Unfortunately I have unwittingly crossposted as you have pointed out. I want to continue in the Queries forum, where I should have posted to begin with. I am sorry.

This is the right thread. I got mixed up thinking the "New Users" forum was a temporary thing so I moved to the Queries forum. Sorry I have confused people. This is the site I'm using now.

Important Note: I have moved my post to the Queries forum. Sorry for any confusion. I thought the New Members post was just for new members. I thought my question was more related to the Queries section. So I moved it. Sorry about the mixed up postings.

My problem is finding a Running Total calculation that helps me keep track of how I'm going. The database is in a Horse-Racing context and I want a column/field that gives a progressive balance of wins and losses on a given day(s). I've tried using DSum without much success but have gotten...

My problem is finding a Running Total calculation that helps me keep track of how I'm going. Original post moved to Running Totals in Queries by jDraw

I've joined the forum to find an answer to an Access problem. Running Totals/Sums. Or progressive sums. It is in a Horse Racing context and getting an answer to the problem of Running Totals. My tables are normalised and the table that holds the main betting data is where I want to get a...