Peckris

This what you're looking for Peck? That's the feller! Agreed - very confusing having the dates along the top.

I'm afraid so. See, his dad's 1st in line, so I guess he is 2nd in line??, and his kid will be 3rd. Or maybe I've got it wrong and must kneel at the block with my neck bared.

You are quite right that I don't know all the ins and outs of databases (or spreadsheets for that matter), in fact I find computers incredibly depressing things to use as they frequently don't give me the answer I want - usually because I don't have enough in depth knowledge of a program. All I need is something that I can understand and use easily to provide me with the information I am seeking to collate together with an image of the coin which I can compare with an illustration in another catalogue and so record the new coin within an existing provenance, or I can generate another known example of that type. In the case of the example above I know that its provenance is ex E W Wigan (collection bt by Rollin & Feuardent 1872), H Webb 560, J G Murdoch 194, G Hamilton-Smith (1913) 126, K Vaughan-Morgan 336, V J E Ryan 1307, J R Vincent, J G Brooker 1153, 3 x SNC references, A Morris (from Roddy Richardson) and finally me (from Lloyd Bennett). It is no help to have the details neatly tabulated out of view from my perspective as the list of names immediately tells me which coin it is, just as the auction catalogue will have a list of past owners underneath the description. This is why putting all the names into one box works so well for me. Any system that requires a single field entry for each name dismembers the provenance. Having a link to the image allows me to compare a new catalogue reference with an existing provenance. The beauty of databases is that you can create a separate layout just for provenance information, with any other identifying information for each coin that you need to see. Then to see all your provenance for all or any coins, you just switch to that layout and there everything is.

Coin and Medal News

I haven't managed to find one. I phoned Spink earlier today, they don't have the book in stock, but I did manage to find an old thread on here which gives JJerrams address as: PO Box 63, Stockport, Cheshire, SK4 5BU That's as far as I have got..... John cannot be contacted at that P.O. address anymore. I have his email address if you want it Bernie. Just drop me a PM and I'll pass it on. It wasn't a book as such - more a pamphlet with hand-drawn illustrations.

I doubt the 1926ME is as rare as you're making out, in Fine and below. I found two in circulation when it was already an established rarity. Ok, not a very scientific poll, but I never found a 19KN or a 50 or 51. It's in VF or better that its rarity truly bites.

shame it isnt connor ;D anyway heres the database that i made tell me any that you would like pictures of blagh says im not permitted to upload a file why is this ? Maybe it's too big. The max single file size here is 150kb. Try http://rapidshare.com/ Click the yellow upload button then the select files button. Has this worked guys http://rapidshare.com/files/449833048/Jims_Coins_1.xlsx No, despite being well used to SnailShare, and downloading it ok, for some reason Office won't let me open it in Excel. Is it that horrible x on the end by any chance? People occasionally send me .docx files until I snarl at them and they send me a good old .doc instead. Is this the same problem? Will it upload in .xls format?

No doubt Wills and Kate's first born .... [yawn zzzzzzzzzz] [oops I nodded off there for a moment ] .... will be called Victoria, and he will be Victoria II. (Yes, I did say "he" ) . . . . . . . . . "ORF WITH HIS HEAD"

Forgive me saying so, but you sound like a spreadsheet user who is not really au fait with database subtleties? In the above case, you wouldn't keep your sales reference data in your main table, but in a separate related table with COIN-ID links between the two. In your second table you would have a matrix / array / recurring field (call it what you will) with as many repetitions as you think you may need over time (30 say). You then populate from occurrence 1 onwards, and that's your table. Then in your main table, you define a portal to the second table in either one of your existing layouts (or create a new layout for it), and there you define exactly how many of the field's occurrences you want to display - i.e. from 1 up to the full 30, or expand as you go. So you don't need those 14 extra columns you'd be stuck with in a spreadsheet, you'd only need how many you decide you want to see, and arranged in whatever pattern suits you, unlike the inflexible grid format of the spreadsheet. I know how to do this in FileMaker, and believe me, Access will allow much the same.

Weird. Maybe they were feeling generous? Or maybe they've a whole bucket-load they're feeding out in tiny dribs and drabs

Looking at your "bolder" example, all the legend shows signs of a double bounce (everything's a bit doubled), which would be enough to blur such tiny letters (and the initials TB are well blurred along with the larger dots). That's what I think may have happened.

Like Mac magazines, I find Coin News rather boring and a letdown. The editorial, some of the latest news, the readers letters, and an article every now and again ... just isn't enough to sustain my interest. Coin Monthly had its death-traps too, but there was definitely more in it.

My betting (I hope it's not true) is that he will not post it, will claim that he did, will refund your £7, then quietly rephotograph and relist in a few months.

Yes you did! I'm just surprised that Colin Cooke hadn't spotted what it was. Either that or they were having an off day.

Perhaps, to link those two posts, the photographer of the second is to be the official photographer of William and Kate's bash? By the way, I own a gilded 1977 crown, even LESS desirable! I just got a beautiful high grade 1907 farthing that some kind soul has gilded. I suppose I could list it on ebay as "Possible gold proof Edward Farthing" and start at £1000? Oh yes - the "I've got a half sov here, guv" hopefuls of the Edwardian era Many a lovely farthing spoiled by that tactic I do have two high grade George IV farthings - one is evenly gilded but slightly dull in appearance, the other has a glorious lustrous sheen, but sadly the central portions have rubbed off leaving the underlying purple.

......you may have to wait some time, their in decline in uk wetlands. ccgb2010 is priced at six guineas, do the same tax rules apply to guineas, were they ever used for currency? In the Great Recoinage they were replaced by the Sovereign so they are not legal tender as far as I'm aware. However, people still called 21 shillings a Guinea and this makes it £1.05 today, so times that by 6 for 6 Guineas and that gives you £6.30, the price of the book. It was used as legal tender originally being equal to 20 shillings but then increasing in the late 1600s (I think) to 21 until 1816 of course. I don't think they have the same tax rules. Sion Tell that to those awfully nice chaps who organise horse races!

Perhaps, to link those two posts, the photographer of the second is to be the official photographer of William and Kate's bash? By the way, I own a gilded 1977 crown, even LESS desirable!

Em an Arab tae, originally a whitfield boy but moved tae Lochee I'm quarter Lebanese... does that count? Only if I can score some of it

I've always thought he had an unfortunate name... Probably why, when I was at school, he was called Canute Or maybe that was just so's schoolboys could say "pissed as a caNute"

Is it my imagination, or is she described as VICTORIA 1 ? (Which strictly speaking, she was, of course..)

Yes that's true. But since I was already a dab hand with FileMaker, it made sense - when I made scans of my coins - to put them into a FM table rather than dump 'em into some folder (and the FM table is password protected too).

a prime example being the 1940 Single Exergue line penny... when was the last time I saw one of these sell for 'only' £40?! Last year, when i bought one from Colin Cookes for 30 quid in BU....oooh did i say BU, maybe its UNC, i don't know any more I think they must have mis-identified it az - it was the late great Colin Cooke himself who told me in the mid-90s that he'd not seen one for five years and it wouldn't sell for "less than £20". My own cost me about £5 in 1978 (a great year for buying!) but they weren't classifying it back then It was certainly about before then. I remember it back to the 1960s but it's never really had any official standing which makes me think it's a comparatively recent phenomenon. I wonder if an (even) older coiny than me has any recollection? Seaby's 10th Ed (1960) jumps straight from Unc to FDC. Whereas Elizabeth Gilzean's 'Coins - A Collector's Guide' (1968) mentions 75% EF, UNC (bag marks but nowt else), BU and then 100% FDC (perfect mint state) so I'm wondering if it slipped into common usage somewhere in between the two dates? By 1970 when Finn & Dowle's Coins For Pleasure and Investment was published they state that Unc is a modern term and means a coin that is perfect to the naked eye and that BU is only really useful when referring to copper or bronze. Interestingly they refer to FDC as an alternative to Unc. All a bit imprecise it seem to me! BU was in common use by 1968 when I first started to buy Coin Monthly.

11 votes for 20 sites or fewer 4 votes for over 50 sites Very little in between those I guess that proves it then : you're either a total obsessive, or you're not!

You have an Access table (file) of pictures with an associated unique Coin ID for each picture. You also store that same unique ID against each coin in your main table. Finally, you establish a relationship between the two tables based on Coin ID, and simply set up a picture field that brings in the relevant picture based on the relationship. It sounds more complicated to explain than to set up. Yes - the more RAM you have, the less the problem will manifest, but Excel itself probably has an overhead position where it will start to slow down on very large files, but I have absolutely no idea what that size is.

Or you could just toss it in your salad Toss what?