Search results

  1. 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
  2. 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...
  3. 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
  4. 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 ? ? ?
  5. 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...
  6. 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
  7. 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
  8. 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
  9. A

    72 Fields on a MsAccess 2007 form

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

    72 Fields on a MsAccess 2007 form

    Thank you Uncle Gizmo for your introduction to ChatGPT Agen. Nicole
  11. 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
  12. 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...
  13. 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
  14. 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...
  15. 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
  16. 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
  17. 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
  18. A

    72 Fields on a MsAccess 2007 form

    We have 3 Excel Spreadsheets with 24 columns on each sheet. Can we have 72 fields containing this data for ONE item on a Ms Access 2007 form using Tabs? Thank you. Crystal
  19. A

    Percentage Change in Value

    P.E.R.F.E.C.T. Thank you, this was the only combination that we did not try. Nicole
  20. A

    Percentage Change in Value

    Thank you for your suggestion Bob on helping us obtain a percentage for the field “Net_Share_Cost”. Using the same formula I have tried to get the percentage for another field “Percentage_PS” but the formula does not work. Could you please advise me as to what I have done wrong? Crystal
Back
Top Bottom