Search results

Vince, I don't think your queries can give powerbuilder the required Account Balances i.e. Account No. 1 42250 Account No. 11 42250 Account No. 1101 31500 etc. This kind of summing for "Parent Accounts" is used in many accounting systems. DLB

Thank you! Thank you very much Jon K. That worked a treat. By drawing a pentagon and a 6-sided polygon, I was able to visually build the queries for nP5 and nP6. You have provided a simple way to do it and its codeless. Thanks again. DLB

Jon K, I have been trying some VBA code to display nCr and nPr but have not been successful. I find your solution to display nC3 and nP3 by means of queries very interesting and simple. I tried to modify your queries to display nC4 and nP4. I succeeded in the nC4 query but have not been able...

Check out this thread http://www.access-programmers.co.uk/forums/showthread.php?t=70644

You can build a Totals query. In query design, add the table, then drag the Account Name field to the first and the second columns, and drag the Amount field to the third column. Click on the Totals button on the toolbar so that a Total: row appears in the grid. In the second column, change...

SELECT [Ashworth Leeds - Industry Project Table].[Record Number], [Ashworth Leeds - Industry Project Table].[Kerridge Ref], [Ashworth Leeds - Industry Project Table].[Account No], [Ashworth Leeds - Industry Project Table].

Attached was the database that I used to test Jon K's method using a structure similar to your fields and form.

Jon K, Field: FieldName=Forms!FormName!ControlName or Forms!FormName!ControlName Is Null Show: uncheck Criteria: True Wonderful, easy solution! Quite unlike the suggestion that we frequently get of using the Criteria:-Forms!FormName!ControlName or Forms!FormName!ControlName Is Nullwhich...

Thank you, EMP. When I first came across the Microsoft KB Article, I was so confused. But after reading your explanation, I am now able to understand it completely. With the dynamic query, we don't need to test whether the text boxes on a search form are left blank or not, because the +...

I am eager to learn. EMP, Keith's results showed that your statement is 100% correct. I am eager to learn. Can you tell me why we must declare Where as a Variant and use + to concatenate strings here? Thanks.

Jon, Thanks for the clear explanation. Now I understand the query Design view and SQL view much better.

Jon, Thanks for the sample database. Never thought it was that simple and easy. Really appreciated it. Thanks again.

Jon, I wanted to try it out, as it is a good way of directly using Excel functions in Access. But I'm no good at arrays. Is there a better way to pass values to an array than the following when there are many records e.g. 100: Dim arraySpeed(100) For i=0 to 99 arraySpeed(i) =...

I am just curious. How do we know <>False in the criteria is one of Access's query grid defaults? Not =True?

Thanks Pat, Putting single quotes inside DateValue() works:- intCount = DCount("TransNo", "tblTransP", "TransDate BETWEEN DateValue('" & Me.txtFromDate & "') AND DateValue('" & Me.txtToDate & "')") Obviously we need to use the DateValue() function to change the strings back to date/time to...

There are usually more than one way to do a thing. Since you are not interested in knowing how to make your original code work (I find Jon K's suggestion works), you can create a query e.g. Query1:-SELECT * FROM tblTransP WHERE TransDate Between [forms]![formName]![txtFromDate] And...

Can we surround date fields with quotes? When I surrounded a date with chr(34), I just got a data type mismatch error: Run-time error '3464': Data type mismatch in criteria expression.

Maybe not If you take a look at the sample data in the first post, you will notice that you can't remove any number at all as they are all smaller than the result.

I don't think a math prof can help much. For 20 records, there are 1,048,575 combinations. Just think of the time it would take to go through the combinations, even if you got lucky and could get a match halfway through.

Jon K, Thank you so much. I did some testing. I changed the Short date style in Regional Settings to m/d/yyyy and the # sign worked. Now I know that on my UK systems, I shouldn't use the # sign to delimit dates. Thank you again! Doris