Search results for query: *

Thanks guys! Yes, all the records that I want to change do not have a comma in the name. I'll give the CHARINDEX a shot.

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

That worked. Thanks!

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

Thanks guys for clearing up for me! Makes sense now

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

Opps I just saw the problem. I had the wrong table alias reference inside MAX. Please disregard this post.

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

Thanks for the article link! I'm excited to try this out. I also had a thought after posting. If I could find some way to run an update query which would search and change the abbreviations to full words. Like change DIST to DISTRICT or SCH to SCHOOL. Then I would get more matches. But how...

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

You can disregard this one, guys. I found a solution by putting the main query in brackets and making a sub-query and then doing the LEFT JOIN in the outer query.

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

I tinkered with it some more, and it looks like it is working now. Just needed to see if I was completely off track.

Boris, that query would give me the exact opposite of what I need. I need to find people who do not have a date 06-01-2013 or greater. If I try to change it and say <> then it pulls every single payment record for each person that is not equal to 06-01-2013 or greater. The NOT EXISTS has got...