Search results

  1. G

    Archaeologist from Bristol

    Welcome, David.
  2. G

    Need Help - Syntax Error (Missing Operator)

    You have 4 ( and 2 ). It is unclear where the functions end.
  3. G

    Introduction

    Welcome to the forum!
  4. G

    New to Access

    Welcome to the forum.
  5. G

    Newbie question..Please don't flame.

    Hmmm...hard to give you anything but the most general of answers with such general information. Do you have the table layout? Is there a rule for what you want what field set to? With that information, it should be easy to formulate an update query.
  6. G

    The Pending "Fiscal Cliff"

    This can be done. President Clinton and a Republican Congress did it in the 90s. Question is, will we have leaders leading or... ???
  7. G

    Filtered displays on subform tabs

    Table: Events ID Date Description Etc Table: People ID NameStuff Etc. Table: Attendance ID PersonID (FK from People) EventID (FK from Events) Comments/Etc Table: StuffThatCanBeBrought (a loose categorization just to demonstrate the concept) ID Description Category Etc Table: EventSuppliers...
  8. G

    Intro

    Welcome, yewagner!
  9. G

    Hello from the Great White North!

    Welcome, Trappergirl!
  10. G

    New Member

    Welcome, Andrew.
  11. G

    Unique Index

    Drag. Sounds like it's broke and nobody wants to acknowledge it. I really appreciate you guy's responses. I'll be able to work around the bug with your help! Thanks!
  12. G

    Create Duplicate Rows

    I think you're trying to do this: http://allenbrowne.com/func-concat.html The first time I tried this, it took forever. I don't know that I'm any better at it now than I was. HTH
  13. G

    Unique Index

    I've run into an oddity using a unique index. First let me review the rule. Let's assume a simple thing like a person's name: ID - Surrogate Autonumber key FName - Text MName - Text LName - Text Just for argument's sake (not because I believe it), you should not be able to store information...
  14. G

    Question Export 01-JAN-2011 format to a txt file

    I assume you're using a query to get the data to export. Your query should look something like: select format(mydate, 'dd-mmm-yyyy'), myothercolumns from mytable where myconditions = somecondition Take a look at...
  15. G

    Assigning queries to forms as recordsets on the fly

    Sorry I haven't posted in so long and am showing my laziness by asking this instead of figuring it out myself. I would like for my users to be able to write a query and then assign the query as the recordsource for a form. This will allow the advanced user to re-use already designed...
  16. G

    Levenshtein Distance

    I can't even begin to wrap my head around BigTable. It looks like that is the ideal way to do what google does and it seems like an ideal way to replace distance algorithms. I actually considered using google earth or google maps to resolve my business problem but so many of the businesses in...
  17. G

    Levenshtein Distance

    I've tried just about every method known (at least, every method known by me). In the OP's case, he is dealing with something moderately simple (comparing 1 horse name to all other horse names). I am confused by looking at the samples, however, because there is no indication that there is more...
  18. G

    Levenshtein Distance

    All distance algorithms take a lot of time. Yes, I have use the Jaro-Winkler algorithm in the where clause and it takes forever. I finally decided to do the Jaro-Winkler distance calculations in the select clause (it still takes a long time) and store the results in a table with the primary...
  19. G

    Looks like the site is infected and admins don't have idea about it.

    Man, I hate those surveys viruses.
  20. G

    Use PK to kick out duplicates

    You know what, now that you mention it, I re-read the post again and I see it the same way. That pretty much invalidates everything I've said in this thread, at least for this problem. Thanks for setting me straight.
Back
Top Bottom