What I am trying to do is enter a name in one cell lets say cell D. I would like Cell C to automatically have a 1 in it. I am counting the number of people for a monthly total. Any ideas? I enjoy using Access, but have yet to attain a high skill for it! Thanks in advance.
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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Automatically Enter A (1) in a different cell
- Thread starter Perk76
- Start date
olgaportland
Programmer
If you are using Corel's QP you don't need to enter a 1 anywhere. You can simply count the names using @count(range such as d1..d50) in a cell outside the range and the number of entries will be counted and displayed in that cell. Access must have a similar function. You might get a better answer in the Microsoft: Access Tables and Relationships Forum.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question