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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Finding record in subform
TrekBiker, I found the most help with searches/filters from Allen Browne. http://allenbrowne.com/ser-62.html Marvin M [shadeshappy]- MarvinM80
- Post #3
- Forum: Microsoft: Access Forms
-
Nesting Iif staements
Just in case you need to watch out for a NULL value, it's easy to work in the NZ function to take care of that. For example: Nz(dblLossGain , 0 ) Another gotcha you might have to look out for is if dblCostBasis = dblDiv. There isn't an If statement that covers that condition. I don't know...- MarvinM80
- Post #6
- Forum: Microsoft: Access Forms
-
Problem with getting Max of table values
JPL, Yes, the Domain function/methods are cleverly disguised queries that do all the behind the scenes stuff for you to give you things like Count, Sum, Average (and other) items in a domain. In most cases you can think of a domain as a column in a table. For more info, check the online Help...- MarvinM80
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
