Recent content by lrdave36

Thanks for the replies. I figured it out. My column was already using a concat function to combine two columns into one. I did a paste special - values into a new column. Converted text to number and now the format is working!

This is driving me nuts. I have a phone number field that is not in phone number format. Example - 3234526666 I want Excel to format it as - (323) 452-6666 I've tried right clicking on the cell - Format - Special - Phone Number, but nothing changes. Even in the sample, it does not show...

That worked great. Thanks!

Hey guys, I have an access report that contains a total field. The formula in the field is =SUM([PAB_AMOUNT]). The problem is PAB_AMOUNT contains some amounts that I don't want included in the summery. These amounts occur on another table field called WAGE TYPE for wage types 9348 and 9349...

Hey guys, I'm dealing with a problem that really is a result of poor table design. It's a simple address table, but instead of creating a field for address line 2, the table contains a second record for the same business. Ex. NAME ADDRESS CITY STATE ZIP LINE NUMBER...

Thanks George. You make some good points here. I can't thank you guys enough for all your help. I've learned a lot posting here on this forum.

Thanks Markros! I'm still having a hard time letting go of the old ways. lol The where clause is easier for me and I only use inner joins.

I am trying to join two tables which both share the social security number as a common field. The problem is the fields are not the same datatype. In one table, it is varchar, and the other table has the field as integer. Is there any way around this obstacle? Maybe a function that...

Thanks George, that worked! I actually had tried inserting the entire CASE statement in the GROUP BY, but I had END AS STATUS as well.

Hey guys, SQL keeps complaining that A.STATUS is not valid in the context with the GROUP BY. Am I doing something wrong here? SELECT distinct a.mbr_ssn_nbr, b.mbr_f_nm, b.mbr_l_nm, sum(c.mbr_svc_cr_yy_ct) as TOTAL_YEARS, sum(c.mbr_svc_cr_mm_ct) as...

Hey guys, I'm stuck on how to code this query. Here's what I'm trying to do: Pull records where the retire_dt2 date is not occuring before 01-01-2009. I tried this, but it failed: SELECT Distinct A.RECIP_SSN_NBR, STRIP(B.MBR_F_NM) CONCAT ' ' CONCAT (CASE WHEN B.MBR_M_NM = ' '...

Thanks George! I didn't know you could put the whole case statement in the Group By. Just to clarify, I don't need Group By if I am returning only the min function results. I think the fact that I am also selecting the mbr_ssn_nbr field requires the Group By. Makes sense now.

Hey guys, I have to create a backup file of our database, and it has been a long time since I've done this action. I remember most of the procedure, but I'm a bit uneasy about creating the database backup file name. Do I have to give it a *.bak extension? I selected file type bak and just...

Thanks guys, it's working now!

Kinda puts me on the right track, but I can't use a temp table. I'm dealing with thousands of records here. I tried this: select distinct A.mbr_ssn_nbr from dsnp.pr01_t_mbr_sys A and a.mbr_ssn_nbr not in (select mbr_ssn_nbr from dsnp.pr01_t_mbr_sys b where a.mbr_ssn_nbr =...