plog's latest activity

  • P
    plog replied to the thread Problem closing a form.
    It's this code: Forms!frmMlFamilia!Childtype!FldName.ColumnWidth = 3660 Forms!frmMlFamilia!Childtype!FldUni.ColumnWidth = 1200...
  • P
    plog replied to the thread Advice when working with dates on form Between StartDate AND EndDate.
    This is just too confusing to debug. What's the purpose/context of that query? No matter its purpose, I'm pretty sure its incorrect...
  • P
    plog replied to the thread Solved Need some advice on a Total query.
    How do you want the dates to be given to the query? Calculated? Input from form? Other?
  • P
    plog replied to the thread Solved Need some advice on a Total query.
    This should be TotalTime: Round(Sum((( [CounterTo]-[CounterFrom])*([CycleTime]+[Detachment]))*24),2) AS TotalTime
  • P
    plog replied to the thread Solved Need some advice on a Total query.
    You should be able to just merge your queries. Take the SELECT / WHERE / GROUP BY /ORDER BY of the second, the FROM of the first, make...
  • 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...
Show older items
Top Bottom