Search results for query: *

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

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

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

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

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

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

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.

Hey guys, I am trying to do a query that will show employers who work in two different agencies for the same month. I'm finding this a bit tricky due to the table records. Each employee has multiple records in my history table. A new record is created for each month so it could look like...

Hey guys, I am trying to write a query that will show me anyone who has a gap or missing time period in their payment date records. For example, a normal record would look like this: SSN Payment Date 113335656 2006-12-01 113335656 2007-01-01 I want to find people...

I have a query request that has me stuck. I think it would be easiest to explain by showing the desired results first: recip_SSN mbr_ssn seq_nbr agency 123445555 444557777 1 NAH 123445555 444557777 2 NAH This particular result set is what...

Hey guys, I have a query request to return all employees who do not have service history. One way I can do this is to look for anyone that has zero months and years of service. For example, I have this simple query select distinct SSN from history where service_years = 0 and...

Hey guys,I have a field on a form called tracking that is a bound text box. When the user goes to add a record to the form, I want this text box to automatically populate with the next tracking sequential tracking number in the table. I have an old Access 2003 database that accomplished this...

Hey guys, I have a field on a form called tracking that is a bound text box. When the user goes to add a record to the form, I want this text box to automatically populate with the next tracking sequential tracking number in the table. I have an old Access 2003 database that accomplished this...

Hey guys, I am trying to design a query that will do the following: Return employees who have both N and K plan code values in their history table. Sample table SSN DATE EMPR_PLAN_CD ____ ____ _____________ 11233333 2003-04-01 N 11233333 2005-05-01 K...

Hey guys, I don't wanna mess with update statements unless I'm 100% sure this will work. The requestion is simple. I need to add the value 0 to end of each three character code name. Here is a sample of the table: code description ____ ____________ UAK UKRAINE VEB...

Hey guys, I have two queries that use derive tables, and I need to combine totals together to get a grand total. I can do this manually on the spreadsheet, but it is so time consuming. First I have this query for payouts: SELECT A.CTY_ID_NM AS COUNTY_NAME...