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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel Logic Question
I'm trying to do the following: countif(range,">1 and <100") but it won't let me use two criteria joined by an and. i've tried to find a between criteria function similar to the one in access but it doesn;t seem to exist. any suggestions???? souprog- souprog
- Thread
- Replies: 8
- Forum: Microsoft: Office
-
Problem with time?
I'm summing a field in a query that is a short time format. The problem is that when then field sums to more than 24 hrs it rolls back to 0:00 and continues adding. For example, the if the result I should get is 38:30, it gives me 14:30 (ie. 38:30 - 24:00). How can I stop this from clicking...- souprog
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
-
Need a user prompt entered like * string function
I am running a query that prompts the user to enter a string. How do I get the query to return all records that start with that string. I'm curently trying to use "Like[Enter Account]*" in the criteria, but it doesn't work. cheers souprog- souprog
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
-
How do I lock the main form record, but edit subform record
I have my main form record set up as a department in a drop down list (combo box) based on a table. The subform then produces the relevant records for the dept selected and asks the user to edit one of the fields. Once the user edits the subform field the main form field is also edited (the main...- souprog
- Thread
- Replies: 3
- Forum: Microsoft: Access Forms
