Search results

IN (a subquery) is inefficient. If the table is large, you will be better off going back to the earlier two Between...And... approach. .

We normally put only one field in a combo box that is used as query criteria because a query can recognize only the value returned by the Bound Column of the combo box. And if either the true-part or the false-part of the IIF criteria doesn't use the = operator, we can't put the IIF expression...

You can temporarily change the MaxLocksPerFile value. See Method 2 in this link: http://support.microsoft.com/kb/815281/en-us .

In Access, a query which is joined/linked with a Totals query or contains the SQL statement of a Totals query is non-updatable. Instead, you can use a domain aggregate function:- UPDATE rlnAPOppServLine SET rlnAPOppServLine.PercentAlloc = 1/DCount("*","rlnAPOppServLine","SAPOMID='" &...

Can you post a stripped version of your database, preferably in Access 2000 format, with just some sample data, the queries and the form for us to have a look at it? .

You can do it with a series of two queries. Run the second query in the attached sample database. .

If the Record Source of the subform is the query, you can simply requery the subform from the On Click event of the search button:- Me.yourSubformName.Requery .

If the Format() function has not been used in the calculated field expression and parameters, then probably the filter expression has led Access to think that the parameters entered are two text strings. You can try declaring the data type of the parameters used in the query. In query Design...

Without seeing your tables and queries and how they are linked, it's hard to see exactly where the problem lies. But as I see it, when [blinks_test_end].[Reading_Date] Is Null, deducting one day from it will still be Null. Based on how you have described the situation, I believe I have pointed...

Like is better. As Like is supposed to work properly only on text fields, it's surprising it can work on a date/time field and can do it relatively faster than DateValue() on a large table. .

In query SQL View, add the Where Clause:- SELECT ...... FROM ....... WHERE DateValue([dateTimeFieldName])=Date() .

Need some more detail. What is [blinks_test_end]? Is it a form? Assuming it is a form, you can use a subquery in the query like the following: SELECT ............. FROM ............. WHERE [TableName].[DateFieldName] = (Select Top 1 [DateFieldName] from [TableName] as S where S.[DateFieldName]...

Since IIFs work from left to right, try this: IIF([Bill Date]-Date()+20<=0, "Discount Expired", IIf([3% Discount]=Yes, [Bill Date]-Date()+20, [Bill Date]-Date()+30)) AS [Discount Days Remaining] which returns the number of remaining days (in Text strings because of the "Discount Expired" in...

The values of a Yes/No field are: True, False; Yes, No; -1, 0 So remove the quotes surrounding Yes. The quotes are for text only. IIf([3% Discount]=Yes, [Bill Date]-Date()+20, "N/A") AS [Discount Days Remaining] Note: The "N/A" will change [Discount Days Remaining] to text strings. If you...

Access treats what is typed in a text box as one single value. Since all you need are two dates, you can add another text box on the form and change the Where Clause to reference the two text boxes separately:- WHERE Table01.IMP_CUTOFF_DT In ([forms]![frmreport]![txtsqldate1]...

See the sample database in this thread:- http://www.access-programmers.co.uk/forums/showthread.php?t=103312 .

Try changing the Where Clause to:- WHERE Table01.IMP_CUTOFF_DT=[forms]![frmreport]![txtsqldate] .

You can enter the distance between each pair of towns once: TownFrom TownTo Distance A B 10km A C 20km A D 30km A E 40km ............................ ............................ B C 50km B D 60km B E 70km ............................ ............................ C D 80km C E 90km...

The two formulas are inconsistent and they don't look like growth at all ?! .

You can add a numeric ID field to your table, number the records as 1,2,3,.. to 8 in the ID field and run this query:- SELECT a.Numbers, Nz(a.Numbers- b.Numbers)+0 AS Difference FROM [TableName] AS a LEFT JOIN [TableName] AS b ON a.ID-1 = b.ID; Just curious ... but why do you have a table with...