Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. lionelhill

    Two simple queries or one nested 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...
  2. lionelhill

    Two simple queries or one nested query?

    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...
  3. lionelhill

    repairing a linked list (or: a return to the Circular Lavatory problem)

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

    repairing a linked list (or: a return to the Circular Lavatory problem)

    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...
  5. lionelhill

    repairing a linked list (or: a return to the Circular Lavatory problem)

    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...
  6. lionelhill

    repairing a linked list (or: a return to the Circular Lavatory problem)

    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...
  7. lionelhill

    Pattern problem.

    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...
  8. lionelhill

    Lookup that isn't

    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...
  9. lionelhill

    Pattern problem.

    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...
  10. lionelhill

    Excel Formula returning Zero

    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...
  11. lionelhill

    Names on Destination Worksheet

    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...
  12. lionelhill

    Auto enter sequential numbers into cells without 'pulling' handle

    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...
  13. lionelhill

    Screen Resolution

    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...
  14. lionelhill

    incremental charges

    ... 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...
  15. lionelhill

    incremental charges

    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...
  16. lionelhill

    Nested IF statements drive me crazy.. Win Excel vs MAC Excel

    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...
  17. lionelhill

    code to look up data from another table

    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...
  18. lionelhill

    Search Forms

    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.
  19. lionelhill

    apothecary's scales

    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...
  20. lionelhill

    apothecary's scales

    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.

Part and Inventory Search

Back
Top