Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. BigChinoDon

    Looping through variables for multiple queries

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

    Looping through variables for multiple queries

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

    Counting child records

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

    Sorting crosstab by fiscal month

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

    Sorting crosstab by fiscal month

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

Part and Inventory Search

Back
Top