I want a field to save with 0.00
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
How do I get a field to save only when that particular field becomes 0.00.
The field is based off a query where it is the balance. I want an error to
occur when it doesn't equal 0.00 and prompt the user to get the equation
down to 0.00. How can this be done???
.
Relevant Pages
- Can you use a combo box in a selct query
... I know when I build a query that I can prompt a user to answer a question, ... which will filter the data. ... Prev by Date: ...
(microsoft.public.access.queries) - TransferSpreadsheet
... I'm trying to export data from a query to excel but I need the 'save as' ... dialog box to prompt the user for a file name. ... Prev by Date: ...
(microsoft.public.access.externaldata) - Re: Checking Tadoquery for changes
... > Is there anyway I can check a query for changes? ... > Reason being, I don't want to prompt the user to save the information on ... Prev by Date: ...
(borland.public.delphi.database.ado) - Re: syntax error for Update Query
... I figured out finally that there is no need to store the balance... ... >> What I need to do is update a table with the results of the Dsum Query. ... Prev by Date: ...
(comp.databases.ms-access) - Complex Select Query
... trying to calculate a field called BegBal (Beginning Balance). ... field called YrPrd which is a long integer that describes the Year and Period ... together a query that does this - any help? ... Prev by Date: ...
(microsoft.public.access.queries) |
|
