Hi, I'm trying to pass multiple query criteria from form controls. I'm using the following type of syntax for the criteria: Like Nz(!!,"*") And this works...

Try this -- SELECT tblSite.Site, tblSite.Lab FROM tblSite WHERE tblSite.Lab = IIF(!! = 0, Between -1 AND 0, -1); -- Build a little, test a little.

Thanks Daryl, I changed the SQL and it works. -- mmk "Daryl S" wrote: MKuria -

Thank you for the feedback; I appreciate your help and the suggested modifications, they are much better. I still have some questions that I need help...

I have a union query between 2 related tables, and where they may be records in one table with no value in the other . I've got this (below) query written,...

I've been reading many posts but still trying to comprehend the union of crosstab queries. I need to take the weekly count of estimates that take under 4...

SELECT valveID, Max() FROM YourTable GROUP BY valveID ORDER BY valveID; If you have a duplicate valveID/Mas of Date combos, it will return all ties. You...

You can use a LEFT JOIN from Table1 to Table2 if Table1 always has a date or the reverse if Table2 always has a date. -- Build a little, test a...

The query has table twice, with second instance having suffix _1 to appear as and they both check for nulls. The same could be accomplished like this -- New...

can you append the results of several crosstab queries into 1 table? I'm calc different categories & customers and need to capture "hours" for each area for...

DontKnow - You can use Conditional Formatting on the field. You are limited in the number of options you have, but it can do what you want. -- Daryl...

Does your query have a start time and end time. If so, you can't run the query to see your time on Paper with Paper still open as you will not have an end...

Hi, How do I get the 2nd minimum value and the 3rd minimum from a table after I have done MIN query for the 1st minimum value? SELECT dbo_CON.SC,...

The below query works well as a Select Query. But when I turn it into an update query, I get a whole lot of nothing in the results. Interestingly, if I try...

Not sure if anyone knows the answer to this but I welcome any suggestions for things to try. I have a crosstab query layered off of a Union query. I also...

I use the following formula in Excel and it works...I now want to do this in a query. Can I add it as an expression in the design grid in a seperate column...

I have created an update query to update a master file. When I run the select query to view the records I need to update - I see the correct data. When I...

I get a "type mismatch in expression" when saving a query. Why do I get this and how do I correct this? My suspicion is my customerID and barcode fields are...

what is the best way to go about doing this? i just created a report that first runs a query for current month info in teradata sql assistant and exports to...

I am creating a table with a "make table" query. I want to query by customer number than by date of order. I want the customer number to be ascending while...