Recent content by Alanlives

Solved! :D (Is there a way to mark this whole thread as solved, or is than an admin / moderator task?) PS. For the benefit of those who are seeking a similar solution, I ended up with this: NewField: "P" & StrReverse(Right("00000" & Hex(Sum([TableOrQueryName].[FieldName])),5))

Sorry, it's been a long day. (Partially) ignore that last post... I got confused. If I were to calculate each number as five characters (with a "P" in front of them, like so)... "P" & ##### ... how would I go about it? If the hex number is less than five characters long, can I make Access...

Hi again, I've been playing with the database trying to make it smaller, neater and simpler. In so doing I have discovered a little problem with my hex calculator... If the resultant hex number ends in zero(s), Access is removing them from display when it runs the query (and calculates the...

StrReverse() ... genius! Thank you very much for all your help. As a final thought... what's the best way to "automate" the process from start to finish, as David R helpfully summarised it: As it stands, I have: Table1: "SalesID" (pk), "SoftwareOptionName" and "Included?" (Yes/No) fields...

Atomic Shrimp, Thank you! What a great suggestion. This is certainly an easier way to do things in Access rather than faffing around with the groups of four. I can't believe I didn't think of it myself! The only trouble is that the eventual license string comes out backwards... I don't...

Hi, you can use "Ctrl+." to switch views in one direction, and "Ctrl+," to switch views in the opposite direction. Try it to see what I mean.

Here is a screenshot of what I have done in Excel, with the formulae used in red. Could you help me recreate this in Access? Thanks again to everyone for your input so far - I'm immensely grateful!

Hi David R, thanks for your contribution. I should have mentioned, the license string has to become a string of hex values in order to be compatible with my license key generation software. Although I understand there are easier ways to do the job, I'm afraid it is a case of tailoring the...

Thanks for your reply, Atomic Shrimp. I've had that thought myself. Okay, I am producing a piece of software that is sold as a base product plus any combination of additional features that the user requires. Think of it like a 'pick 'n' mix' with software options. Incidentally, these options...

Hi, Thanks so much for your reply. I need to create a Sum value for each group of four in the column, rather than ending up with one total value for the whole column. For example, if the first eight values in the column are 1, 2, 4, 8, 1, 2, 0, 0... I want to calculate the sum of the first...

Hi everyone, Sorry to ask a specific question with my first post! I've been playing around with Access 2007 for a couple of weeks without asking anyone, and have Googled and searched this forum but I think a new thread is necessary... The end task is to generate a (hexadecimal) code to...