Search results for query: *

ooh, thanks for that. Another very neat approach to add to the toolbox; I will try it out. It's also great to be reassured that Access can handle stacked and unusual queries. I have a lot of respect for the AllenBrowne site, but it does deal with a vastly greater range of access queries, and...

I'm trying to work out how to sum a numerical field "A" in one table, where a ThingID field in that table has no matching ThingID field in a second table. My first thought was to do this in two queries: one would sum "A" for the whole of the first table; the other would be a straightforward...

Here is a possible solution, for those who are interested: I love little algorithms like this.

I need to go and work through your solution on a bit of paper! Thanks for the ideas! I also realised, thinking about it, that my people-lavatories analogy begins to break down, because my solution (yet to be posted!) finds the node actually at the junction, whereas to repair the list we need...

I'll let you count how far your pointers have moved, but I don't think it will help you. Sending one pointer/assistant off at half the speed of the other is indeed a good way to find out whether the list has become a circle, but it doesn't (on its own), I think, give you enough information to...

A while ago, I posted a puzzle based on an algorithm for finding out whether a linked list has become circular (obviously just walking round the list is no good, because the algorithm has to have a definite end-point if the list IS circular! Computer-crashes versus computer-doesn't isn't an...

Yes, ChrisHunt. Misunderstandings are at the root of nearly all disasters. I would bet half a Mars-bar that nearly all big IT catastrophes that end up costing the public sector millions and get on the front page of newspapers (and probably also the private sector equivalents) are because someone...

You might not want MATCH with zero as its final parameter. When you are looking up numerical data, sorted in order, "0" will force MATCH to return only an exact match, but you might find you've got data for 135 and 136, and you're looking up 135.5. In this case, you can use -1 or 1 to return...

I'm also late to the party, but I'm going to have a moan. It's a nice puzzle, but I'm worried that puzzles like this won't recruit the best and most creative staff (well, depending on the job, at least). What the question really asks is "Who thinks most like me?". If you want a problem-solver...

You can, if you try really hard, get Excel to display the sum of two cells that ought to sum to "10" as "0". For example, if you set this up in a cell where someone has been trying to be clever with number formats, and has used the custom number format: 0, Then the result will be displayed...

Thank you, both, for posting this; I learnt something (totally irrelevant but worth learning) as a result: I don't often copy a complete worksheet within a workbook, but you made me wonder what would happen if I did so, and the sheet I was copying had a named range on it. There would then be...

If you don't want to fill the series with genuine values using the handle on the corner and Fill-Series, there are oodles of ways to get a set of cells containing sequential numbers using formulae. My usual is to put =A1+1 in A2, and then copy down as far as I need. This has an application if...

The easiest way to get rid of all the Accessy bits like the ribbon is simply to run the database in the Access Runtime rather than the full access. You can do this by changing the file extension to ".accdr" instead of ".accdb", by adding "/runtime" to the link in a shortcut that runs the...

... oh, forgot the obvious. If you do want a solution that calculates the answer in a single cell using a standard table of prices put at any convenient place, and if I'm understanding correctly what you want to do, it's probably easier to write yourself a user-defined function than to hope for...

Let me guess: I think what you want to do is calculate a cost of, say, 34000 units of something where the first 1000 units cost price X, the next 2000 units cost price Y, the 5000 units after that cost price Z etc., so the total price is actually a sum of a whole series of prices multiplied by...

Just a brief extra: (1) If asked to do something more complicated, involving more than two different commissions, resulting from more than one threshold overhead, an easy way to do it is to avoid if()s altogether, and instead put in a table of overheads and corresponding commissions, and then...

I wouldn't use DLookUp, because you're actually looking up something quite complicated based on several fields, and you may have multiple hits. You've got a transaction table for loans that presumably includes the BookID, the ReaderID, DateOut, DateDue, and DateIn as a minimum. What you're...

No, you almost certainly do it not like you put in the code, but very much like you put in the explanation: ...."[Amount] <= " & Me.qAmount..... Amount is a value, not a string. In a way, it will behave more like your dates than your strings.

Very original and a nice thought! Thanks kwbMitel. I regard it as a nice bonus that I'll maybe add if I think of a rewording of the original puzzle. I think if I'm strict about it, the original still stands, as it asked for a precision of 1g, and didn't offer a promise that every item weighed...

Thanks for spotting my typo and reading the thought instead of the words! I'm a biologist by training and therefore can't do maths.