Recent content by giz

OK I got this to work, but where do you put the SQL code calculates median for all types? Is this a seperate query?

Hi, I am trying to get this to work in a query but when I run the query I get a Run-time error '3061': Too few parameters. Expected 1. I am a VBA newbie, what do you put in the function for the "pgroup" string? From the above dataset would you put in the actual type value, i.e. "T1". I think...

Thanks. This seems to work OK. :cool:

yes, that is what I need to do. The current siteiid value is actually the ranking of that siteiid field in one of the original tables (table:site) being queried, of which there are over 900 records. That is why values are 450, 451, etc. . The query takes a subset from the "site" table, and info...

Hi, I have created a query that accumulates various columns of information from different tables. In this query the user selects, as criteria for a "musym" field, a value (i.e. 38E) of interest for subsequent export of the accumulated information for that specific value into excel. However...