Queries

Not In (SELECT DISTINCTROW
Thanks for taking the time to read my question. I want to use a field in a table as a list of items to filter out in a query. I have this: SELECT tblWebLog.[cs-user-agent] FROM tblWebLog WHERE (((tblWebLog.[cs-user-agent]) Not In (SELECT DISTINCTROW "*" & ExType & "*" FROM tblExclude))); but I get the... 28 Mar 2010 19:00

return product with maximum price
How do I write a query that returns the product from each order that has the highest price? Each order can have multiple products, so there is an intersection table that links the Orders to the Products. Here are the relevant tables: tblOrders OrderID (pk) CustID (fk) tblOrderProd OrderProdID (pk) Order... 29 Mar 2010 10:15

update query
Hi I want an update query, that deducts 20% from the value of a field [SOH], assuming that [SOH] is greater than zero. I also need the resulting figure to be a whole number. ie not ending in 0.25 or 0.5 etc. Any help would be greatly appreciated. Many Thanks Alec ... 25 Mar 2010 13:49

Repetitive Results
>>Is there a way to get one concise answer that will state all present allergens? Search on Concatenate by Duane Hookom. If that does not help then post back what your desired output would look like. -- Build a little, test a little. "tasha" wrote: I'm trying to design an allergy statement query. So... 25 Mar 2010 16:16

Changing recordsource.. query in comboboxes
Hi, I posted this question but it.. didn't came up in Forum so am posting again... I created to combo boxes in the form.. e.g. Individualone Individual2 now on bases of Gender I want to change record source in the boxes.. if individualone box fetch male then individual2 box should fetch Females a... 31 Mar 2010 21:04

How could I SELECT the max of 2 different fields?
Hi all, I have a select statement like this: Select Max(A_Date), Max(B_Date) From blah blah blah... How could I have my select statement to return the bigger (later) value of these 2 selected fields? Thanks. ... 25 Mar 2010 05:46

SQL searches
I've got a table with computer names and IP addresses in different columns. I would like to do a search that returns all the computer names that aren't unique (i.e if there are more than one computer with the same name). Any ideas? ... 25 Mar 2010 15:02

Nested IIf and IsNull
I can't seem to get to syntax right on this query field. The nesting goes this way: find City Name by: if JobAddress4 and JobAddress3 is blank then get leftmost characters of JobAddress2(always populated) up to ",", if JobAddress3 not null get leftmost characters of JobAddress3 up to ",", and if JobAddress4 not... 25 Mar 2010 08:00

What is wrong with this equation?
What is wrong with this? Results:[item]![old_sku] In ("11111654","11111656","11111658","11111659","11111660","11111803","11111881","11111882 ") When I put that as a field in a select query and run it, I get either a 0 or a -1. This is fine. When I use that field as the Column Heading in a crosstab query... 26 Mar 2010 10:24

Multi List combo as criteria
Hi and TIA. I have a multilist combo box on my form, but don't know how to setup my query to reference all the values selected in the combo. If you could point me in the right direction I would appreciate it. Thanks! -- Reggie ... 24 Mar 2010 20:33