Search results

Thanks Crystal, I'm so glad you're here to help me! I did think to reduce the PaymentTypes, I set it as 20 characters maximum. I'm glad to hear I'm on the right track. So with the various payment amounts, are you suggesting, for instance, that I create one table specifically for the fees...

I've just finished implementing your suggestion in terms of creating two new tables, PaymentType and Payments. It all works very well. However, when I run a query, there is one column for payment type, and another column for the amount. Ideally I'd like a separate column for each payment type...

Thanks Crystal! I'll take a moment to get my head around it, then see if I can make it work.

Hi Crystal, Many thanks again. I've changed the zero cells back to null now, as I'm convinced that that'll be better in the long run. I'll try what you suggested, about entering the second argument in the Nz function, as I think that might well have been the reason it wasn't working before...

My database is coming along well now, thanks for your help so far. I've got a quick question before I enter too much data. I have multiple currency fields in the EngagementsPlayers table. I initially left blank records blank, which I believe are referred to as null? This caused problems when I...

Thanks very much! I feel like I'm making progress now.

I've got a hopefully simple question! I want to implement most of the ideas that you suggested Crystal. That would involve me effectively cutting and pasting field columns from the main table to new tables. I thought that would be straightforward, but I can't work it out! What's the easiest way...

Many thanks Crystal for your detailed reply, I really appreciate your help. I need to read through it again, but I think I understand most of it. Also, thanks for the practice file to play around with. I'll give that a go. I'll probably be back soon with some more questions!

Hi Gasman, Thanks so much for your detailed reply, that's very helpful. Good idea about the instrument field, there are a handful who play both. At the moment I just entered both in the same cell. I'll have a think about your suggestion regarding the Engagement/Musician intermediate table. I...

Hi everyone, I've read through the Access Basic book that Crystal recommended, thanks again for that. I've just got a few questions to get me to the next stage. To put it into context, I do the bookkeeping for a freelance orchestra, and there are about 700 musicians on the database. On the...

That's great, thanks so much. I'll definitely read that book, it sounds perfect. That'll keep me occupied during the lockdown!

Many thanks for your replies. I only just noticed them now! I'll look into normalization tomorrow, to see what that's all about! Thanks for the heads up.

Thanks for your advice. You make it sound simpler than I was anticipating. My code refers to columns and rows, whereas in Excess I read that they are called records and fields? Can the autonumber field create a new unique code, consisting of three letters (first three layers of surname)...

Hi, I'm quite new to Microsoft Access, and have a couple of tasks I'm trying to complete, which I'm hoping someone can give me some advice, so I can get started please? Firstly, I have been using Excel as a database. I created a form to create a new entry to this database, and when I submit...