Search results for query: *

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

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

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

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

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

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!