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!

  • Congratulations bkrike 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: *

  • Users: mward04
  • Content: Threads
  • Order by date
  1. mward04

    Query expressoin is too complex???

    I'm not sure why I'm getting this error, I'm hoping someone can help me out. I'm using the query below and when I do a date range of 3/1/06 to 3/31/06 I get an error that says the Query expression is incomplete or too complex. However, when I do the same query from 2/1/06 to 3/1/06, there is...
  2. mward04

    Multiple expression query

    I am running a query with one expression that calculates standard deviation. I want to calculate standard error as well so I created an expression within the same query to do so. However, I now get asked to enter a parameter value for the standard deviation and the CountofAcctNum. When I just...
  3. mward04

    Query for Times Past Midnight

    I imagine this has been solved in another thread, I just cannot find the answer to my question. If you know the thread, please let me know. I've been spending too much time on this and can't find a solution. I have 2 times in an XL spreadsheet: Arrival and Discharge. When I look at the...
  4. mward04

    Form won't save

    I have no idea why this is happening so any help would be much appreciated. I've been creating a client interface with command buttons linked to macros. Initially when I created this main form, everything was fine. I went back to add a button that enabled another report to be run but when I...
  5. mward04

    Calculating # of Days in past 3 months

    I am trying to create a query that will allow me to enter a date range, say between 4/1/02 and 5/1/02 (This part I've got). However, I want to know how many calendar days there are in the previous 3 months to 5/1/02. Anyone know how I would go about doing this??? In other words, I want to...
  6. mward04

    Numbering Items in Report

    Anyone know how to itemize/number each new subject in a report? Is there a simple feature to do something like this? Thanks! Mike

Part and Inventory Search

Back
Top