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

    Group Footer Average on a Report

    Figured it out...was having a problem cause there were some zero length strings in there that I wasn't catching.
  2. cedar72

    Group Footer Average on a Report

    I have report based on a query that calculates the time span between two date for each record base on one group. In the footer for each group I would like to create a field that shows the average time for each group. Not sure how you go about creating an average here...any help would be appreciated!
  3. cedar72

    Filter out weekends in query?

    Thank you everyone! Raskew, your solution proved to be the best fit...thank you!
  4. cedar72

    Filter out weekends in query?

    cmmrfrds.... Not sure if I follow...I need to count the weekdays between the two dates...not sure how your where clause is going to help
  5. cedar72

    Filter out weekends in query?

    I am trying to creat a simple (I hope) query that will bring me the number of days between two dates and filter out weekend days. So if it was between Friday and Monday the count would be two. here is the SQL as I have it now.... SELECT Neighborhood, Lot, Block, [Crit Dim Requested], [Actual...
  6. cedar72

    Sending parameters to asp

    I am having the same problem...did you ever figure this out?
  7. cedar72

    Passing a param to ASP???

    Passing parameter to ASP??? 12/4/2002 11:41:12 AM Cedar I have a link in my details section on my report that I want to be able to go to an ASP page that is generated off a query to a SQL DB, the query needs 4 parameters. How can I write this link to look at the current record in the...
  8. cedar72

    I have a link in my details section on my report that I want to be able to go to an ASP page that is generated off a query to a SQL DB, the query needs 4 parameters. How can I write this link to look at the current record in the details of the report and pass parameters out of that? here is the...
  9. cedar72

    Need Help with a trim type query

    Thanks so much guys....big big help
  10. cedar72

    Need Help with a trim type query

    thast a big help thanks! They are the same size now but may change...so what if I need to bring out the numbers between the decimals and then after the decimals? And yes it is a text data type.
  11. cedar72

    Need Help with a trim type query

    I am trying to figure out how to get a set of account numbers (ex. 100.1250.51220) that are already sorted by department (middle four digits 1250) to then sort by a range of numbers (.51200 - 51299). Any ideas of how to strip to find those middle numbers in Access?

Part and Inventory Search

Back
Top