Queries

Old form references in MSysQueries and MSysObjects
This query show me forms i once had in my Access 2003 database. [code] SELECT IIf(Left$([Name],1)="~",Mid$(GetPart([Name],"~",2),5),[Name]) AS Form, MSysObjects.Owner, MSysObjects.Name, MSysQueries.Attribute, MSysQueries.Expression, MSysQueries.Flag, MSysQueries.LvExtra, MSysQueries.Name1, MSysQueries.Name2, ... 25 Jun 2008 11:54

Changing Criteria in Access Queries
Folks, Hello. I am have just started looking at writing VBA but having my challenges, please excuse me. Here is my problem. I am running four queries where I am having to manually input the criteria to generate the output to Excel - individual reports. I have 70+ people to do this to. Is there an easy w... 25 Jun 2008 12:56

Eliminate duplicate addresses for mailings
Access 2007 Vista Business I have a table with names and home addresses. There are valid duplicate addresses because of multiple people in the same home. How do I construct a query to eliminate the duplicate addresses so that I do not send to mailings to the same address? Thanks, Will ... 26 Jun 2008 12:34

Parse Name
I have a field that contains last name but includes parenthesis, in which I would like to remove. Ex. (Keller). How can I remove the parenthesis on each side? Thanks in Advance, Lisa W. ... 25 Jun 2008 15:00

Datediff question
I have datediff commands in two queries and I am storing the differences in tables. I am using datediff("d",[date plans received],[date plan review letter sent]) in both queries. I am getting some squirelly answers. On one set of dates, it works fine. One will be 6/12/2007 and the other 6/19/2007 and it will re... 25 Jun 2008 12:56

modify crosstab query to fiscal qtrs rather than calandar qtrs
I need to provide quarterly data based on our fiscal year, not the calendar year. I am able to create a crosstab query, but don't know how to modify it for our fiscal year. Thank you ... 26 Jun 2008 04:20

Is there a way to do a not INNER JOIN?
Hi, I got a table with 10 elements (ie: 1,2,3,4,5,6,7,8,9,10) and another one with 20 k (ie: 1,20,3,50,11,1,2,10, ...) I would like to do an INNER JOIN between those 2 tables but would like to return all elements that are not alike. Not sure if join can do than. Thanks ... 25 Jun 2008 15:00

Query parameters held in separate table
Greetings, I am writing queries to look for keywords. I would like to have the keyword criteria held in a keyword table to make it easier to update, find duplicates, share, etc. I tried a couple of different ways but could not make it work. Any ideas? -- PRD ... 25 Jun 2008 11:54

Calculated Field
I am trying to devise a calculated field (Epires:) with a formula/function for the following account types. Type 1 expires 1 year from issue date (9/1/07 expires 8/31/08). Type 2 expires, not to exceed, 6 years form issue date on 9/30/XX (9/1/03 expires 9/30/08, 10/12/07 expires 9/30/12, 7/31/07 expires 9/30/... 25 Jun 2008 12:56

SQL Syntax Error
I'm getting a Syntax Error on this. Any Suggestions? Thanks DS Dim OUTSQL As String DoCmd.SetWarnings False OUTSQL = "UPDATE tblTimeLog SET tblTimeLog.LogTimeOut = #" & TIME & "#, " & _ "tblTimeLog.LogDateOut = #" & Date & "# " & _ "WHERE tblTimeLog.LogTimeOut = " & Null & " " & _ "AND tblTimeLog.LogDateOu... 25 Jun 2008 12:56