Recent content by hatchback

Thanks Cronk Problem is, I need the table to be permanently there...not sure what to do about it. Anyone else got other ideas?

Hey everyone In my database, Ive got a table made by a cartesian query joining the primary keys of three tables. The three tables it connects are quite large - each about 2,000 records. The cartesian query gives me therefore a table of about 8 BILLION records. (It takes access about 20 minutes...

Sure, delimiting isn't a problem. Thanks again for your assistance, Pat. I'll go for it and see how it goes. Keep up the good work!

Delimiting the numbers really isn't too tricky. What do you mean when you say it'll create problems? Making it possible for the user to retrieve and manipulate the numbers doesn't seem to me to be impossible to do. For the project I'm doing it should only be anyway a very rare occurence. Of...

Thanks Pat. So you're telling me that if executed correctly (easier said than done), it would do the job? Or do you think that there are other more fundamental problems with this design? I know it's not the ultimate in normalization, but there's nothing about it which is just wrong, is there?

Thanks Pat. Great to be here! Let me be more clear: In the footnotes table, there will be a field for the "Name" of the footnote, which will not be the primary key, just a simple name for each footnote for the user to refer to. The primary key will indeed be an autonumber. I never intended...

Hi guys I've got a table - "Products" - in my database, with a text field - "Info" - which contains info about products. Within this field I would like to have footnotes. To do this, I think the best way to do it is by putting numbers inside the text at the location of where I want the...