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!
-
Table not storing data in consistant format
I'm using an Access 2003 database to store a WBS number in a table. I have a mask set up in the table design to restrict the format of the WBS. The data is 1234-12-1234-123456. The mask is AAAA\-AA\-AAAA\-AAAAAA;0;_ and the field is set to text, and the mask is supposed to store the "-" in...- Mustang86
- Thread
- Replies: 0
- Forum: Microsoft: Access Tables and Relationships
-
SUM [qty] if [inspectionresult]=1
Yes! Works well! and with that the % can be found. =(Sum(IIf([InspectionResult]=1,[qty],0))/(Sum([qty])))*100 I thought I had tried that but I probably had my format messed up. Thank you much!- Mustang86
- Post #3
- Forum: Microsoft: Access Reports
-
SUM [qty] if [inspectionresult]=1
good day. I'm generating a report from a table. The table has.. employee (employee name) inspectionResult (1 if pass, 2 if fail) qty (number of items) and a bunch of other product data that shows in my report. The data from the table is filtered on [inspectionResult]=2 using the report...- Mustang86
- Thread
- Replies: 3
- Forum: Microsoft: Access Reports
