Recent content by BigChinoDon

Thanks Dave, So simple, yet I couldn't see it through my pre-conceived notion of what it should be. Don

I have a fairly complex query I run 7 times every morning. I have declared variable that I have to change 7 times, one for each query. I'm trying to figure out how to loop through the query 7 times, changing the variable in question each time, and output the results to a single table. A while...

Hello, I'm trying to open forms based on child records of the parent. - If no child records exist, open form to add new record - If only one child record exists, then open form to edit that record. - If more than one child record exits, open a form to select which record you wish to edit...

Skip, Thanks for the reply. Yeah I guess calendar month summarization is probably the right term. As the query is for FY-2010, I don't really need to see the year, hence my need for a sort by starting with OCT through SEP. You did get me on the right path. I added a "NOT SHOWN" column to...

Hi all, I work in a hospital and have a database for deaths. The crosstab query (below) works fine, but I need to sort by fiscal month of the US federal fiscal year. October should be the first month through September, the last month. I've thought about creating a second table listing the...