Search results for query: *

Hey guys, I am currently trying to solve a problem in my database dealing with duplicate records. Here's the situation. I have a database for employee tax information, and they wanted to add a field for a checkbox. So I created the field with a YES/NO value. Then I ran an update query to set...

Hi everyone, I am looking for a way to automatically convert our Access reports to individual tiff images. The report is a single page, but it executes a query that pulls in each individual employee data from the table. I have about 10,000 different employees so it would need to generate a...

Hey guys, I'm a bit stuck on a simple query. I can't remember how to use the min function to compare against a specific date. For my query, I want to find employees where their first service date occurs after july 1, 2005. I wrote this query, but I get a syntax error: SELECT SSSN from...

Hey guys, I am having trouble getting my query to select the max date for a specific record value. Here is an example of the table NAME AGENCY HISTORY DATE TEST 00922 2014-02-12 TEST 90212 2012-02-12 I want my query to return the last history date occurring only on...

Hey guys, I am trying to run the following query, and can't see why it is giving me an error on the last line: Basically I'm trying to accomplish two things here: Pull their most recent service date which is stored in mbr_hist_svc_cr_dt Get a grand total of their contribution amounts...

Hi everyone, I am creating a mail merge document for a two page form letter in Word 2010. Everything looked fine until the 13th record where I noticed it was creating a third blank page. I thought I had fixed the problem by adjusting the bottom margin. The blank pages disappeared in the...

Hi guys, I am trying to join two employer tables with similar data, but no primary key exists between them. Employer table A contains the employer id. Employer Table B does not have the employer id. I want to merge the two tables so I can update employer table B with the employer ids...

Hey guys, I have an access form that I created for user entry. The control source of the form is a table where I want to store their data entries. However, my boss wants me to have the form automatically retrieve the employer's name and populate it on the screen based on the employer number...

I am trying to write a query that will tell me the number of employees in multiple categories. It's been awhile since I wrote a query like this, and I just can't remember how to output multiple counts with column names. I first tried a union SELECT SUM(A.TOTAL) AS TOTAL_SCHOOL FROM...

Hi guys, I have a spreadsheet that imports data from an Access database. They would like the spreadsheet to automatically create a column which numbers each record for the printout in sequencial order. So if I import a set that has 20 records, I would have the number column like COUNT 1 2 3...

Hi guys, I have a macro enabled Excel worksheet that I set up to automatically import data from an Access table. I recorded a macro of maually doing the import. Then I placed a control button on the sheet to execute the macro when the user clicks on the button. It works fine except for one...

Hi guys, I am writing a query that will join my addr table to the main query and display everyone's address. The problem is several people do not have an address record so I want to do a LEFT JOIN and have them show up in the query anyways. I keep getting syntax errors when I try to add in...

Hey guys, I am trying to write a query that will do the following: List all people who do not have a payment date of 06-01-2013 or later. My payments table contains a single record for each payment date. ex. SSN anty_pymt_dt 123445555 06-01-2013 123445555...

Hi Guys, I have two tables and I want to write a query that will list all the records that are in my 1099_PER table, but do not exist in the original table. The original has about 18,100 records while the 1099_PER table has about 18,430. I wrote this query: SELECT A.SSN, A.Name4 FROM...

Hi everyone, I'm a bit stumped on this one, but I think I'm on the right track. I need to run a query that finds employees who are currently have more than one employer. The employer is referenced by an agency number. Sample Table looks like this: EMPR TABLE SSN AGENCY...

Hi everyone, I built a query that takes a person's date, and performs a count for each month. Here's part of the query: SELECT A.MONTHS, A.YEAR, COUNT(*) FROM (select A.SSN, A.YEAR, CASE when A.MONTH = 1 then 'JANUARY' when A.MONTH = 2 then 'FEBUARY'...