Search results

I have a query challenge and your advice. In my transaction table, I would like to find out the latest transaction dates of each family models. It sounds a simple Max function can get the desired result. However model number consists of the first 6 characters for the family model and the...

Hi Tal, Thanks for you info. The users would like to type in English in most case. By default, the NBs use English, not Chinese. Occasionally, the user switches to Chinese input by pressing Shift + Alt. When launch the database, the would like to use English by default but now the...

Hi Greg, I tried the demo on two NB computers: one with US English & English keyboard and another one US English & English keyboard or Chinese Traditional Taiwan. Open the form, select the language and highlight the field and enter the text. Unfortunately it won't work on both NBs at all...

Hi GreqZ, It is exciting to have received your response. Definitely I will give a trial and come back with the result. Thank you very much!

Are distinct values not considered a grouping?

Actually, the primary function of the form is for searching the records by entering some key words. On the footer, I have some statistics of the searched result. Count() and Sum() are working correctly. Now it is no luck with DCount. Is it an incorrect setting for the required results? If...

Let me try this alternative to see if it fits to the existing scenario. Thanks!

I use count() for other calculations on the footer of the form. For supplier field, there are duplicate suppliers in the supplier column and I need to count the distinct suppliers.

Can you clarify that DCount cannot be used in form based on parameter query? If I move keyword search to header of the search form, is it ok to use DCount in footer? I need to DCount the suppliers in a recordset based on certain filter criteria. Thanks!

Hi Plog, There was no luck with the modification, still flashing #Error.

Hi Plog, Thanks for your advice. The query, qrySKU-search has a parameter field to do the required search. I changed the code to =DCount("[Supplier]","qrySKU-search"). It produced a flashing #Error in the text box. Since I do not need any criteria, I leave it blank. Any idea to fix it?

I have an unbound text box on the footer of a form in which the control source has =DCount("[Supplier]","recordset"). It did not work and just produced #Error. I just want to count the distinct suppliers in the form. Can someone advise where is possible error. Thanks!

Hi Burrina, Thanks for your pointer. It looks to fit in my situation but no luck to resolve it.

I would like to count distinct values on a control in the footer of a search form. Can someone guide me how to accomplish it. Thanks!

Hi MarkK, I am unsure how to apply it to the query. Could you give me more guidance. Thanks!

I have one field containing a couple of 6 digit codes and would like to count the number of codes in the field and write the number to a calculated field. Each code is separated by a comma and a space. How can I count the no of comma within the field? Thanks!

I found a useful password protected form using input box and tried it successfully. However there are two issues. The password is not case sensitive and the password entered displays in the box. Is it possible to turn the password to case sensitive and the entered password is displayed as *s...

Thanks for your good suggestion!

I have a parameter query in which consists of a search statement as below:- Search: [Model] & " " & [FiscalYear] It works very well. I am wonder if there is any options available to affect the search results. As far as I understand, when I enter the key word into the pop up box, it will...

CJ, Many thanks for your guidance and I have worked it out.