Search results

I use MSAccess to link to an informix db to run reports I create for the users who are given user logins to the informix db. I am not a programmer but can write basic SQL statements. I created an MSAccess query that has a number of parameters - some user input (from/to date) and some fixed. The...

Actually that doesn't work either; its what I started with. The point is, whatever is entered in the control (text box), the application should logically place the last two digits entered to the right of the decimal without the user defining where it should go by pressing the decimal point key...

The users want to see the decimal point as they are entering the data; before they leave the field. If they enter 87450361045, it should show them $874,503,610.45 before they tab to the next field.

where do I place the syntax and what would it look like?

I have workers who only enter currency amounts. They have asked me to make it so they only need to enter the numbers and not the decimal point. I have the tables created but no data as yet so its the best time to get the data types and general settings as needed (text vs. currency, etc.). Since...