Search results for query: *

Hey guys, I've been trying to write this query that will report multiple counts and keep hitting brick walls. Basically, I can get the counts in individual queries, but I can't find a way to time them together. My tables are called COURSE and REGISTRATION-INSTRUCTOR. They share a common...

Hey guys, I am trying to write a query that will return each employee's YTD balance. The problem is in the table, there are multiple YTD balances each one occuring in a specific year and month number. I want to only retrieve the most recent YTD balance. A sample of the table would look like...

Hey guys, I'm a bit stuck on this problem which should be really simple. I'm trying to find out the percentage between two numbers. For instance: I have 33,235 total records I have 5,297 records out of the total that are product A I want to find out how much percentage of product A is...

Hey guys, Well I guess I need to go back to basics here because I'm just not understanding LEFT JOINS apparently. Almost all my queries use inner joins so I rarely have to venture outside of that until today. I am trying to join my payments table to the history table. However, most people do...

Hey guys, I'm a bit stuck trying to join two queries so I can get a single report. Query 1 contains a list of everyone I need on the report. Query 2 shows people's monthly and yearly salary. I was able to do this with derived tables. The kicker is not everyone in query 1 has a salary so since...

Hi everyone, I am trying to write a query that will compare two tables and report the differences. The differences can occur on two levels, screen differences with is a field called USER_TRAN_CD and individual permissions are stored in the fields user_tran_cd, user_inq_cd, user_add_cd...

Hey guys, We've are in a bit of a pickle here at work. We have an Access report that allows users to reprint 1099 forms. Well, the form changed this year, and I've been tasked with editing the report. The problem is the report itself is actually an embedded image file of the 1099 with table...

Hey guys, I have some raw data that I imported into a spreadsheet and I can't get the number format to convert to the correct currency amount. Here is an example: The first amount appears like this and is currently set as a text field: 00142465 I need it to convert to $1,424.65. I tried...

Hi guys, I am stuck on what seems like a simple request: Find all employees who have ever worked in the agency '00401'. Out of that set, also show their current agency number if their status is active. It is the current employer part that is throwing me off. The way to tell if they are...

Hi guys, We just upgraded to a new server and SQL 2008. I set up a maintenance plan to backup the main databases and create a transaction log backup. The plans worked fine for 2 weeks, but now I am getting errors. I noticed that the .bak backup files are being created, but it is failing on...

Hey guys, I have a query that looks for people who are in a certain age range. The query does this by comparing their birth date to the current date. I discovered today the the query is not picking up some people because their birth date is stored in a separate table. I thought I could do a...

Hey guys, I am writing a query that returns an employee name field called F_NAME. I need my query to only return employees that have a single letter for their first name. Can someone tell me how to do this? I'm thinking it's some kind of length function, but not finding the solution today...

I am stuck on this one. They want to see a list of people who have service dates occuring before 07-01-1997. I have a field for service date in the table. The problem is the table contains multiple records for the same person with different service dates. Here is my query: SELECT...

Hey guys, I am trying to create a query that will display as such: Years of Service Count ________________ __________ 1 2640 2 3344 3 2345 So in the above example, 2640 employees have one year of service...

Hey guys, I have table with a field for SSN stored as text. Ex. 222-22-2222. I want to run a query that will return only the last 4 digits or characters of the SSN. Is there a SQL function to do this? I've played around with RIGHT(), but doesn't seem to work for me. Thanks.

Hey guys, I have designed report in Access that prints a person's SSN number as 333-33-3333. I would like my report to only show the last 4 digits on the social. Is there a way to format this directly from the report design? The SSN is a database field in one of my Access tables

I know there has to be a way to do this, but it's been so long since I set something up. I have SQL 2005 Management Studio Express on my local PC. Currently it has connections setup to connect to our SQL server. I want to test and run a script on my machine so I won't be bogging down our...

I have a designed access report that is pulling data out of the wrong table. I need to switch to a new access table. Both tables have the same field names and data types. Is there an easy way to do this? I click on properties in the detail header, but I can't find any setting to show me the...

Hey guys, Two part question here. I have this query: SELECT DISTINCT PR01.AGTY_ID_NM, PR0.PAYEE_NM, PR0.RECIP_SSN_NBR, PR0.RECIP_RETIR_DT, PR02.ANTY_PYMT_TOT_AMT, PR0.BENEF_STAT_CD FROM DSNP.PR01_T_RECIP_SYS PR0, DSNP.PR01_T_EMPR PR01...

Hey guys, I am building an Excel spreadsheets that directly pulls data from a SQL database. One field is a phone number field. In the database, the phone number appears without dashes. I would like Excel to auto format the number and put dashes. Ex. 1235555 displays as 123-5555. Any way to...