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

    Excel: Counting values between two numbers

    Weaselthend, Yep, that's what I was trying to do. Thanks! And thanks to SkipVoight as well!
  2. Gooter

    Excel: Counting values between two numbers

    The subtotal function counted the number of cells which contained values in my range. I couldn't figure out how to use the filter criteria to count how many values were between two numbers, eg. 50 - 75. Example Cells: A1~~51 A2~~58 A3~~40 A4~~57 A5~~50 The result of =subtotal(2,A1:A5) was 5...
  3. Gooter

    Excel: Counting values between two numbers

    Hrmm, I couldn't get that to work. Probably not doing it correctly. I'd really like to use a formula for this though. Any more suggestions?
  4. Gooter

    Excel: Counting values between two numbers

    I have a cell range with numerical values. If I want to count how many numbers fall between a range, how would I do that? I'm trying to use the COUNTIF function and I cannot get it to work when I use more than one variable. Example: This works if I only want to count the values greater...
  5. Gooter

    Counting records in a report

    Forgot to mention... I am thinking that a possible solution is to somehow count the DPM UID for each violation since it is different for each DPM and its locations?
  6. Gooter

    Counting records in a report

    Looking for help counting records on a report. Here is how I have my database setup. Note, I am a very novice Access user. :) Tables: Fields 1. DPM Name: DPM UID, Name, Location [NOTE: a DPM name may have multiple locations, eg. DPM A located at P1/S2 and P2/S4, so each DPM name and its...
  7. Gooter

    Determining if a field on a form is Not Null (blank)?

    I have two fields on a form which passes the user-entered data from only one of the fields to a query in a report. I only want the user to enter data into one field. If they enter data into both fields, I want it to display an error message, something like, "Please only enter info into...
  8. Gooter

    Date functions in query: need to go back certain # of months

    I want the user to enter a date into a form (mm/yyyy) and then I want it to search the database up to 24 months prior to the date that was entered and return the results. So, user enters 6/2003 and it should return everything that has a date between 6/2001 and 6/2003. Here is a basic formula...
  9. Gooter

    Report calling a Form problems

    Ok, that makes sense. Thank you. Is there any way to make the form close itself out or be minimized to the background once you pick what you want to do (Preview, Print, or Save)? Currently, the form stays up and covers up the report if you pick Preview. It requires that it be manually closed.
  10. Gooter

    Report calling a Form problems

    Also posted here thread181-544240 have a Report that calls a Form when it is opened (using the OnOpen event procedure). On the Fform are two command buttons, "Preview" and "Save as File". Preview displays the print preview in Access. Save as File will save the report as an...
  11. Gooter

    Report calling a Form problems

    I have a Report that calls a Form when it is opened (using the OnOpen event procedure). On the Fform are two command buttons, "Preview" and "Save as File". Preview displays the print preview in Access. Save as File will save the report as an .RTF file. Here is my...
  12. Gooter

    Incrementing a user entered value from a form to a report

    That worked! Thank you Trend. I set the "Visible=No" on the two textboxes (txtUserNum and the increment textbox) so they would not appear in the report. I also had to change the formula in the sum textbox to "(txtUserNum + lineNum)-1" because I want the first record in the...
  13. Gooter

    Incrementing a user entered value from a form to a report

    First of all, I am a complete novice with Acess. Here is what I want to try to do. I want to create a report that takes a user-entered number from a form and then auto-increments that number by one for each record generated on the report. For example... 1. The user enters "25&quot...
  14. Gooter

    Incrementing a user-entered # on a report

    First of all, I am a complete novice with Acess. Here is what I want to try to do. I want to create a report that takes a user-entered number from a form and then auto-increments that number by one for each record generated on the report. For example... 1. The user enters "25&quot...
  15. Gooter

    Using a list box in a query?

    Gresford, I like your idea about using the LIKE function; however, I can't seem to get it to work and I think I know why. I actually have two tables: Table 1 - contains the names, address, phone numbers, etc. Table 2 - contains what I want to keep track of. I set a primary key in each table...
  16. Gooter

    Using a list box in a query?

    Thanks for the reply. I think I'm going to need an example. Would you mind posting one? FYI, this is how I set up the query. I picked all the fields I want to be displayed. For the searchable field, in this case "Names", I typed this in the criteria section in the design view...
  17. Gooter

    Using a list box in a query?

    Greetings, Here is what I want to do. I would like to create a query where the user can select from a list or combo box the values that are in a particular field in the database. For example: I have a field called "Names" and in that field there are 5 records, Joe, Steve, Mary, Pat...
  18. Gooter

    Adding data to a table via a form that contains a function

    Ok, that makes sense. I see why I do not need to store the TotalAmt since I am storing the two data fields that comprise the TotalAmt anyway. It's redundant to do so. Also, whenever I would need to output the TotalAmt, I could just use the function "= ctlSalesAmt + ctlMarkUpDown" or...
  19. Gooter

    Adding data to a table via a form that contains a function

    Greetings, I am very much a novice when it comes to Access97. I have never used a database program before and no very little of good database design. Having said that, I'm working on a database project for my company. ;) It's a very basic database. I set up two tables, one that contains...
  20. Gooter

    How to display only one Word in taskbar when multiple docs are open?

    Is it possible to only have Word take up one spot in the taskbar when multiple word docs are open? I have Office 2000 Pro. Thanks!

Part and Inventory Search

Back
Top