Search results

Thank you, June 7 for your reply and question. On the forms, "Yes_1_Investments_StockBrowse_F_High" and "Yes_2_Investments_StockBrowse_F_Update", when you click the "Clear_Yes" buttons, the "YES" in the Table field "Investigate" becomes "NO" While, I have tried using the same code on the form...

We are having an error on only 1 of 3 Access 2003 forms in changing the Yes field to No. Form Yes_1 and form Yes_2 works. The form Main menu does not co-operate. Could I please be advised as what I have done wrong? How would I add the message, “Yes has been removed” as a note after the query...

Thank you June7 for your comments. I have Deleted and Re-entered the problem records and the files now look good. Thank you for your other comments also. Mahi

Could we please have assistance in our Access 2003 sorting problem? When the form opens, we would like the form to be sorted by, Analyst Name / Analyst Company, but for some reason the form has two sorting groups that are not being properly sorted. The same problem occurs at; The top left...

Thank you, GaP42 for your suggestions, which I have tried to follow. This form seems to be running now with no problems after running the Detect & Repair function, Item 1. The sort order now is working with our live data. Item 2. With our live data this function, previously was not working...

A = could we please receive assistance in having the Access 2003 form open with the Analyst_Name in Ascending order, as this sorting does not always work, when the form is opened. B = When the Choose Sorting at the bottom of the form, this also does not always wok C = Irregularly the data...

Thank you ALL for your assistance. I thought that this would have been a simple query to run. Nicole

Can you please confirm that this Query is correct? We would like to print all records if; A = The Trade field contains any of these words = Buying, Purchased or Selling. B = If the Trade field does not contain the above words or is empty, but the Investigate field contains Yes Your assistance...

Thank you all for your suggestions. I was off work while sick and another person tried to correct our problem, without success. Attached is our updated database with the query. The field "One Record" = MUST = contain the word "RESEARCH" Plus if the field "Trade" contains ANY of these words...

Thank you Pat for your suggestion. We are using the suggestion of arnelgp. Fabiola

Thank you, arnelgp for your suggestion, which is producing the results that we want. Fabiola

Thank you all for your suggestions. The Query below is giving us the information that we are looking for. SELECT Investments01_tbl.Stock_Name, Investments01_tbl.Transaction_Type, Investments01_tbl.Investigate FROM Investments01_tbl WHERE (((Investments01_tbl.Transaction_Type) Like "*Bought*"...

Thank you for your Query, bob fitz. What we are trying to print is any records that MAY contain, Transaction_Type is Bought or if Transaction_Type is Purchased or if Transaction_Type is Selling or if Investigate is Yes Any records that MAY contain any of the above choices Nicole

Thank you CJ_London for your note. We would like to print our report if ANY of the individual choices are made

Thank you June 7, for your question. We would like to print our report if ANY of the individual choices are made Nicole

Sorry for my miscommunication. We would like to print a report if ANY of the four criteria are shown. Crystal

Thank you both for your suggestions> What we are trying to do is print a report if ANY of these four criteria's are met; If transaction type contains either of the words, Bought, Purchased or Selling or if Investigate contains Yes. I am sorry if we gave you the wrong information. Crystal

Could we please receive a suggestion on how to have our Access 2003 Query Work based on; If the Transaction_Type type contains any of these words "Bought" Or "Purchased" Or "Selling" And if the Investigate = Yes Your assistance will be appreciated. Thank you. Nicole

Thank you arnelgp for your suggestion. I was able to find an Access 2007 Template to work with. Nicole

Thank you sonic8 for your suggestion which works. P.E.R.F.E.C.T. Nicole