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!
-
Counting each month when only have start/End Date?
Actually (modifying the SQL from the previous replyer), I think this would be a little more accurate: SELECT ProjId, EmpId, Sum(iif(#1/31/2002# between StartDt And EndDt,1,0)) AS Jan, Sum(iif(#2/28/2002# between StartDt And EndDt,1,0)) AS Feb, Sum(iif(#3/31/2002# between StartDt And...- tedlan
- Post #9
- Forum: Microsoft: Access Other topics
-
Using Transferspreadsheet no prompt to select file
Does anyone know the significance of the "&" suffix in the following statement: If IsMissing(Flags) Then Flags = 0&. I know that an "H" prefix in a declaration or assignment statement is hexadecimal notation, and an "O" prefix, is Octal notation. I've seen the &...- tedlan
- Post #6
- Forum: Microsoft: Access Other topics
