Search results for query: *

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

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

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?

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

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?

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

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

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

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.

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

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

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

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

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

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

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

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

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

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

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!