plog's latest activity

  • P
    plog replied to the thread Qry excluding a word not working.
    SELECT Contact_People.* FROM Contact_People WHERE (((Contact_People.Category)<>"Accounts")); This should work as long as there is data...
  • P
    plog replied to the thread SQL problem.
    It can be, but not in this instance. You've got multiple [Family] and [Genus] fields in the underlying datasources so the SQL will...
  • P
    plog replied to the thread SQL problem.
    I'm looking closer now. Have you given us the full SQL? Usually in an unmatched query there is a WHERE dealing with NULL values in...
  • P
    plog replied to the thread SQL problem.
    There is no missing operator, its the spaces in the table name. It either needs to be bracketed in the second instance, or assigned an...
  • P
    plog replied to the thread SQL problem.
    Why did you bracket the first instance of sTable but not the second?
  • P
    plog replied to the thread Display only yes.
    This is complicatedly simple. I think a lot of experienced people would miss it. The only reason I see it is my new reading glasses...
  • P
    plog replied to the thread Display only yes.
    And what was the actual code you put on the Report? You didn't just paste what cheeky typed did you? You changed it to the actual name...
  • P
    plog replied to the thread Display only yes.
    My guess is you were incorrect and do not have a Yes/No field. Go into the design view of the table and tell me exactly what the data...
  • P
    plog replied to the thread Adding up counted records to get a total.
    It's like your mind is stuck on doing this with a DCount and you can't actually see what you truly want. The number of records is...
  • P
    plog replied to the thread Table relational design (Buyers - Payments - Agents).
    That's neither "every" (it's just one) nor "is" (it's not a situation in the present tense, its future imperfect) a reason to store...
  • P
    plog replied to the thread Table relational design (Buyers - Payments - Agents).
    There's no reason for the commission to be stored. You build a query, use math in that query to calculate the commission then...
  • P
    plog replied to the thread Table relational design (Buyers - Payments - Agents).
    1. How is the commission determined? Flat rate->e.g. $10 per purchase regardless of size? Percentage->%5 of purchase? Other? 2. At...
  • P
    plog replied to the thread How to automate Google Maps?.
    The google API is like the continuum transfunctioner, it's mystery is only surpassed by its power. I'm pretty sure you can do this, but...
  • P
    plog replied to the thread Report field base on another.
    Perfect. You need to change your ExpDate field to catch those 0 values: ExpDate: iif(Expiration<>0...
  • P
    plog replied to the thread Report field base on another.
    Semantics time---do you want to not show any of the dates? Or any of the records? There's a difference: FirstName, LastName...
Show older items
Top Bottom