Search results

  1. A

    How to obtain a decimal place in the currency format

    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
  2. A

    How to obtain a decimal place in the currency format

    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
  3. A

    How to obtain a decimal place in the currency format

    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
  4. A

    How to obtain a decimal place in the currency format

    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
  5. A

    How to obtain a decimal place in the currency format

    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...
  6. A

    How to obtain a decimal place in the currency format

    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
  7. A

    Field Formatting

    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 ? ? ?
  8. A

    Field Formatting

    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...
  9. A

    72 Fields on a MsAccess 2007 form

    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
  10. A

    72 Fields on a MsAccess 2007 form

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

    72 Fields on a MsAccess 2007 form

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

    72 Fields on a MsAccess 2007 form

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

    72 Fields on a MsAccess 2007 form

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

    72 Fields on a MsAccess 2007 form

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

    72 Fields on a MsAccess 2007 form

    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...
  16. A

    72 Fields on a MsAccess 2007 form

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

    72 Fields on a MsAccess 2007 form

    Thank You Uncle Gizmo. I thought that we could use 3 tabs (Sub Forms) to separate comparison data for each group, but have now changed the layout to 5 Tabs on the sub form to analyze / display similar data groups. Yes each of the Rows is Related to a unique ID / Key Field. Yes, each row...
  18. A

    72 Fields on a MsAccess 2007 form

    Thank you LarryE, for your question. Yes, we are preparing for the possibility of 72 different specific comparisons. Nicole
  19. A

    72 Fields on a MsAccess 2007 form

    Thank you, Doc Man for your comments. With the current tests that we have run with our 56 Fields everything seem to be working. Nicole
  20. A

    72 Fields on a MsAccess 2007 form

    Thank you Minty for your information, at the present time our Tab Forms have a total of 56 fields. Nicole
Back
Top Bottom