Search results

I / we have been trying to add a new grouping “Watch” for some time without success. The export group “Holdings”, works, but we cannot get the group “Watch” to work. Your suggestion will be appreciated. Crystal

Thank you CheekyBuddha for your suggestion. I am sorry that I did not explain our problem properly. When the value in “Net_Share_Cost” is $0.00. Meaning that this stock was not purchased. Then an error occurs in the field “Percentage_PC”. If the “Net_Share_Cost” field is empty or contains a...

I have not been able to solve our calculation problem “IF” the Net Share Cost has a value of $0.00. (If the Net Share Cost is BLANK or $0.00, it means that this stock has / was not purchased. Your suggestion will be appreciated. Problem – Field = Percentage_PC...

As of January we will be receiving daily data on about 100 items, which can be in a in a CSV or Excel format. Our intention is to store this information for comparison purposes and historical comparison in a MsAccess database. Should we receive the data in a CSV or Excel format? If the data is...

sonic8 T.H.A.N.K. Y.O.U., THANK YOU, THANK YOU. By changing the regional setting on my computer to Canada, my Numeric Values are now correct. Nicole

Thank you sonic8 for your comments. I normally work from our Canadian office, but am currently working from Denmark. Would this be the cause of the problem? Nicole

Thank you Pat for your comments, according to what the three of us in our office have reviewed, we DID follow Arnelp, suggestion, BUT are not receiving the correct Information. Please let us know what we have done wrong? Nicole

Arnelp, Thank you for your suggestion. Could you please suggest a way to add a , (Comma) separator for Thousands and remove the trailing Period, so that the information would be shown as $1,000.00 $6,609.39 $3,017.95 $2,768.78 Thank you Crystal

Thank you arnelgp for your suggestion Results using the new format Data Type – Currency Format - $#,000\.00 Decimal Places- 2 Results - $10.90. (note the trailing decimal) Results - $3800.00. (could we have the comma seperator) Can we get rid of the ( . ) dot at the end of the expression...

Current format Data Type – Currency Format - $#,000\.00 Decimal Places- 2 Results - $1763,00. (note the trailing decimal) = = = Would like - $1,763.00 (without the trailing decimal) Thank you Nicole

W.O.W, I never thought of this before. Do you have an opinion on following Pat Hartman's advice and remove the formatting from the table and do the formatting on the forms and reports ? ? ?

We are getting ready to upgrade our MsAccess databases and would like to have advice on the formatting of the fields that we have been using for years. Attached is the different formats in our MsAccess 2003 database(s) and I would appreciate suggestions on if and how I should change the field...

Thank you all for your suggestions. We have created a form with 3 sub forms each with 24 fields relating to the Excel Spread sheets and this seems to be working. Nicole

Thank You Uncle Gizmo for your video, which I will review while working on our forms? Nicole

Thank you AccessBlaster for your comments, which I agree with. At the present time we are working on using 56 of the fields. Nicole

Thank you Plog for your suggestion, which I will review.. Nicole

Thank you Uncle Gizmo for your introduction to ChatGPT Agen. Nicole

Thank you Mike60 Smart for your request, but the information is Proprietary and are not available. Nicole

Thank you CheekyBuddha Yes, you understand me better than my husband. I am looking to display the data from our three Excel spreadsheets in a single Access form with a Subform that has tabs to organize the fields on the form. I now have 5 Tabs on the subform, with each tab showing data from one...

Thank you XPS35 for your comment. The forms that I have created will be used to display the data for each individual item. Nicole