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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Seeking Help
I think I'm going to drop this for now and go about it a different way thanks again.- plainsman
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
Seeking Help
Basically M_01, M_02, M_03 are my heading for my dates because I had to reformat them into a MMYYYY (012004, 022004, etc.) Below is code I have for a different column that works B_01: Sum(IIf([currdt]=[M_01],[AMOUNT_PARTICIP],0)) This is straight and simple. It goes out to my database finds...- plainsman
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Seeking Help
Thanks in advance for any assistance. I'm trying to learn but this one's got me. Here's what I have: Curdat these are my date and are labeled M_01, M_02, etx Reprice_Freq_Mult = Either M (month) or D (Day) Reprice_Freq = a number I need an expression where if curdat=M_01 and...- plainsman
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
