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!
Recent content by threeunderpar
-
Adding totals of yes/no fields
Create an unbound field on your form or report with a calculation in its control source. In the control source enter: =iif([NameofYesNoField]="Yes",1,0) Hope this helps you.- threeunderpar
- Post #3
- Forum: Microsoft: Access Other topics
-
select query criteria using like
Hey Jesse. In your criteria enter something like this under the address field: Like "*" & [Type the Address] & "*" Hope this helps you.- threeunderpar
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Problem with Query
Doing this in a report structure, rather than a query, would be very easy. Create a new report setting its recordsource to your initial query. In the report, in the View - Sorting and Grouping section, select Field1 from the Field/Expression list and make sure the Group Header is set to Yes...- threeunderpar
- Post #2
- Forum: Microsoft: Access Other topics
