Queries

Update Query Question
Good Afternoon, Wow I am surprised I am having so much trouble with something that is so simple...perhaps you can tell me if what I am trying to do is even possible. I would like to do multiple updates within a single query, can I establish something similar to the "logic" below? Thank you! UPDATE tblWeeklyBas... 8 Jul 2008 20:18

Unformat Phone Number Field
All, I have a database table that has a field Fax_Numbers that have fax numbers saved in the format: (333) 444-5555. I wish to use these numbers in a query with the numbers left justified and with numerals only: 3334445555. I can't seem to "unformat" using the Format function in a query. Your help would ... 8 Jul 2008 20:18

Can you put an IF statement in a query expression?
How can I create this expression in a query FITOK: =IIF(OR( [Status_FIT_Lead]=75,[Status_FIT_Mult]=0),"OK","No") Thanks for your reply & assistance. Jimbo213 ... 8 Jul 2008 19:16

Percentile Formula for Access
I am trying to create a query that will calculate the 25th, 50th, and 75th percentile of salaries within specific job codes. I currently have a table of all the job codes I am looking for and it is linking to a table of all the employees in the company (which includes their job codes and salaries). Does anyone ... 9 Jul 2008 09:35

left "_" & "-"
Here is some of my data that I want to unconcatonate... Need some help with doing this as you can see the data length changes with each change of account. 1300_1 - CASH WA DISTRIBUTING 337100_1 - NORTH CENTER FOOD SERVICE 380009_1 - C & M FOOD 7258_1 - REINHART LACROSSE 216000_44 - SNOW FRESH APPETIZERS 3676_... 8 Jul 2008 23:23

Adding A Leading Space - Update Query
Hello, I need to add a leading space in a field to make the entry 6 digits because I have one table being matched to another but on one the WO#'s that have 5 digits do not have a space in the front but on the other it does. The one that does is 16mil+ records so it would be easier to add the space to the small... 9 Jul 2008 19:54

Formula for quering a range of numbers
I have a database that has a field of numbers in it used to identify aircraft. From this I only need a certain set of aircraft. The aircraft are in the number range 10865-11143. I am trying to figure out if there is a formula operator to put inbetween the two numbers in the query that will let access know to ju... 8 Jul 2008 16:11

dates in queries
Hi, I have a database with titles of articles and a log form. The titles and the log form are in two different but related tables. The log form has four fields: title, action, taken by, and date. The purpose of the log form is to keep track of who is doing what to the article. I want to create a query that wil... 8 Jul 2008 16:11

How do I build a countif expression in Access
I want to build a countif expression in a query. I basically want to count off another query but only if a field in another table is null. ... 8 Jul 2008 15:09

crosstab query question
Store # KO# Threshold Start End 1019 1 $2,025,000.00 5/1/2007 4/30/2008 1019 2 $2,025,000.00 5/1/2008 4/30/2009 1019 3 $2,025,000.00 5/1/2010 4/30/2011 This is an example of some data in an Access table that I have to report to a spreadsheet. The spreadsheet has columns: 1st KO Threshold ... 9 Jul 2008 14:44