Queries

Join 2 tables
Hello, I am a very basic user of MS Access. I love the functionality of it and would love to learn more. Here is my situation. I have started up a query that includes 3 tables. One main database(Table A) and the other two are conversion tables(Tables B & C). The query works with no issues. Now, I would... 10 May 2010 14:21

Update - Microsoft Responds to the Evolution of Community
What is Happening? This message is to inform you that Microsoft will soon begin discontinuing newsgroups and transitioning users to Microsoft forums. Why? As you may know, newsgroups have existed for many years now; however, the traffic in the Microsoft newsgroups has been steadily decreasing for the past sev... 10 May 2010 03:22

NETWORK MARKETING
NETWORK MARKETING ****-------------------------------------------- http://sites.google.com/site/projecttrackingsoftware ************* http://sites.google.com/site/networkmarkettings ************** http://sites.google.com/site/spywareantiviruses ... 9 May 2010 02:30

two access table in one query
i design a report with access database i prepare a query with two table without joinning but the query return data more than one time Please solve my problem as soon as possible ... 8 May 2010 21:06

IIF STATEMENT
When i write the following IIF statement i get the error mesage WRONG # ARGUMENTS. What am i doing wrong? K:IIF([PL5HX4.RK]=1,2,0IIF([PL5HX4.RK]=2,1,0)) tHANKS ED ... 10 May 2010 13:13

Cumulative Unique Record Count
I am trying to write a query to count the number of unique SKUs that have shipped, cumulatively for each week in a quarter. My data looks like: Week SKU Quantity 14 200 50 14 300 100 14 300 60 14 400 80 15 200 400 15 300 200 15 400 60 15 500 20 16 400 10 16 400 800 16 600 600 16 700 20 The output t... 10 May 2010 17:41

Parse Suffix from Last Name Field
I have a last name field where the suffix like JR, SR, III, II, etc is part of the data. How can I parse the suffix and leave the last name? TIA ... 7 May 2010 17:52

Linking Excel Into Access Issue
I am using Acc 2003, but Acc 2007 should work the same (I think). I have linked an excel spreadsheet into my Access database. Almost all of the fields are available and can be read. There are a few fields that I can see in Access, but its in Excel sheet. These fields were using a VLookUp function in excel... 7 May 2010 14:32

Delete Records from Table using Query Results
I have a table named "Records" that contains a field "Customer Number". I need to delete all the records in table "Records" if the "Customer Number" is also in the table named "Transfer". Is there a simple way to accomplish this? Thank you! ... 11 May 2010 08:57

Date query allowing user to enter dates
HI I have a DB where I am trying to set up a search criteria using 2 tables and one field out of each. Table - Services Field - Service Table - Appointments Field - Appointment Date (format = dd/mm/yyyy) How can I set up a query where the user can input to select appointments between 2 d... 7 May 2010 14:32