Search results for query: *

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 =...

hey guys, I am creating a query that will simply list everyone who does not have a stat_cd of 3. I discovered a problem when I found one account that did have a stat_cd of 3 even though I specified in my query to ignore all 3's. The problem has something to do with the fact that they have...

I think I figured it out. I saved the file as a macro enabled template or workbook instead of a spreadsheet file.

Hey guys, I'm trying to design an auto-import for an employee which will automatically import Access table data directly into Excel. The easiest way I found is to record myself manually doing the import and save it as a macro. Then create a command button that will launch the macro. I was...

Hey guys, I've gone about as far as I can in Access 2007 without having to dig into VBA. I need to learn how to write VBA coding inside Access 2007. Can anyone recommend a good tutorial for beginners? I downloaded Microsoft's Visual Basic and thought maybe I should just get familiar with the...

Hi guys, I have a text file that has the data broken up into 3 different sections. It is fixed width. I need each section to be placed in a seperate table. Is there any way to do this in the import wizard? I could specify a line number as the cut off point.