Queries

Query Speed
Hi there! I am setting up a database for our branch offices to use in a distributed (FE/BE) format, and am wondering which would be better for speed: 1. A distinct table for each branch, with a UNION ALL query forming the basis for regional/countrywide reports. 2. One massive data table that queries would la... 23 Mar 2010 17:12

Query to add fake records from table
I have a table that contains real data and then I have a table that has dummy data that is needed for another program that I'm sending the file too. I need to figure how to put them in the same colunm in the table. Here is my statement. "Station Name & Item: [DBA_DEVICES]![deviceName] & " " & [DBA_ITEMS]![it... 28 Mar 2010 21:12

Find matching records based on two fields
Hi, I'd be really grateful if someone could please assist with my query. I'm trying to identify all records where [Source] is equal to 'Atlas' that has matching records in [Species] where [Source] is equal to 'Museum' OR 'Survey' as per example below... Original Table: UniqueID Source Species 1 ... 24 Mar 2010 02:15

Update Queries
I have two tables an Employee table and a Gap Table. Both Tables have the Social Security Field (SSN) in them. I also have a UPI field (unique personal ID) in both tables. In the Gap table the UPI's are null. What I need to know how to do is How do I update the UPI in the GAP table with the UPI in the Employee ... 24 Mar 2010 18:11

IIF Statement Query??
I have four fields in a table that contain an identifying number. I want to write a query with an expression that looks for the first field that contains a value and return that value. If the first field is null, I want the next field to be looked at, if it has a value, I want that value returned, if it is null, ... 23 Mar 2010 10:09

Query Help
Good Morning, I have come here for help a few times but due to security access at the time I was unable to post the info needed to get my issues resolved. I hope someone can help. I am currently creting a training database that will list 1. All Employees 2. All Equipment 3. The Employee's training level o... 22 Mar 2010 15:33

How to Strip HTML tags from data
I'm querying a MS Share Point list and need to strip HTML from the query results. Is there a way? ... 22 Mar 2010 23:02

View unavailable
I'm have 2 tabels. The first table have list of rooms and the second table have list of orders of customers(content RoomId feild and the fields incoming date and outgoing date). I created a query that show all the availables rooms(by Distinct sql function) but i want to show all the unavailables rooms. How c... 23 Mar 2010 09:00

Combine Format function?
Hi, I have a field called TransDate that is in the format 01/01/2010 and I want it to look like 2010Jan. Is there some way to combine the Format function or should I be using some other function? Thanks for the help, Kay ... 23 Mar 2010 11:20

Update Query
How do I create an update query to automatically assign the create date of 9/24/2009 as the end date for for the record with the create date of 9/15/09. ID CATEGORY DURATION CREATE_DATE END_DATE 2381 Service 13 - 24 months 9/15/2009 9:35:00 AM 2381 Service 13 - 24 months 9/24/200... 22 Mar 2010 09:24