Recent content by Jane221

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

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

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

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.

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...