Search results

  1. J

    Two queries

    As in EMP's post, just two lines of code will do: DoCmd.OpenQuery "QryDbtM1" DoCmd.OpenQuery "QryFuelM1"
  2. J

    Incorrect results from query

    I saw two different syntaxes of Nz() in this thread. Nz(...)+0 Nz(..., 0) Is there any difference between them? Thank you!
  3. J

    How do I correctly reference a VBA Public Function in a query?

    Just eager to learn something new - to me. Could someone tell me what "xxth percentile" is? Many thanks!
  4. J

    How can I select only the rows I need?

    Thanks, EMP. I ran a test and found that two queries with an inner join did run faster than a query with a correlated subquery. I'm glad I found these forums. I can learn a lot here.
  5. J

    How can I select only the rows I need?

    I'm learning SQL statements and would like to ask you experts a question. Is it advisable to use as few queries as possible? (I ask because I have no difficulties in understanding the two SQL statements in Jon's post, but I have not come across the SQL syntax in Cosmos75 post before.) Many...
Back
Top Bottom