Queries

Update a number field incrementally
I have an orders table containing 4 fields: Order number (text), order date, ship date, and Reference (number). Orders are appended to the table daily, probably 1000 orders at a time. The reference field is blank or 0 when the orders come in. I would like to assign the reference number incrementally by 100, actuall... 22 Feb 2006 07:59

How do I capture just the date from date/time field in an SQL Dat.
I'm creating a query in MS Access and I want to extract just the date portion (02/14/06) of a date/time field from an SQL Database table. How do I structure the DatePart function in the query or is there another way to code this? ... 15 Feb 2006 11:18

DSUM Function Criteria
I'm writing a DSUM expression with the hope of calculating a running total with each record. My current DSUM expression is providing a running total based on the OrderID rather than each line. Here's what I'm currently getting with the DSUM expression listed for the table named "Order Details": Running Total... 15 Feb 2006 17:05

Equivalent of the Oracle In (select *)
Does anyone know how to do the equivalent of the Oracle In within Access SQL? Oracle will let me do: delete from TAble_a where (f1,f2) in (select f1,f2 from Table_b) This incredibly useful syntax lets me tell Oracle to essentally join table a and b then thow away all the matching rows in table a. Access will ... 14 Feb 2006 12:51

Query Field Heading
Is it possible to create a field that is based on the results of an if expresion. IE I have three fields imported from a table. Value Number Day. I want to create another field that will result in 1 being entered if the number = 2 on a Tuesday. Thanks ... 12 Feb 2006 19:38

Converting Text to Number
I want to convert Text records to Number within a query. My table is too big to change the data type in the table itself. Someone told me to use the expression builder to create this expression: Expr1: [MasterAvailabilityData]![ActualAvailPlant]*1 This did not work. I need to convert this one field to Numb... 10 Feb 2006 15:46

objective to put in a resume
i am creating a resume, for the first time, can u please help me put a convincing objective ... 10 Feb 2006 10:32

Query to give the number of weekdays in a given month
How would I write a query to give me the number of Mondays, Tuesdays, Wednesdays...etc. in a given Month and Year? The Month/Year would be from a form to use in the criteria of the query. Example: Month/Year, January/2006 Results: Sun = 5, Mon = 5, Tue = 5, Wed = 4, Thu = 4, Fri = 4, Sat = 4 Than... 8 Feb 2006 11:32

Calculating distance with radians
acos(cos($a1)*cos($b1)*cos($a2)*cos($b2) + cos($a1)*sin($b1)*cos($a2)*sin($b2) + sin($a1)*sin($a2)) * $r; I would like to convert the above excel formula to us in an access query to calulcate distance between two cites. a1,b1,a2,b2 are lat & long and are in degrees so I must first convert to radians. R= radius... 5 Feb 2006 19:27

Statistics in Access 2003
I'm trying to calculate the chi squared distibution in a query but am clueless how to build such an expression. em ... 2 Feb 2006 15:36