Posts Tagged 'Expressions'
Thursday, June 19th, 2008 |
This was certainly a player Elton Rueb and he even managed to solve before I help. What the reader was intended to measure the time it takes a user to insert a record and it has three fields: one for the start time when it opens the form, for the first time to end that is inserted when you click the record button and a field to calculate the difference. This is a simple example but may be lacking to those who want to calculate difference between two times. So the Elton Rueb (Rio de Janeiro - RJ - Brazil) provided the example that could help someone else.
Download: Test Time
Posted in Dates , Samples , Examples transferred , Expressions , Form , Time | 2 Comments »
Thursday, June 12th, 2008 |
The reader Jacinto put a question here on how to change the format of a date of 12/06/2008 for 2 0 0 8 0 6 1 2, the response as explained in the comments is as simple as a text box with the following expression:
= Format ([date field name], "mm dd yyyy")
and properties of the field put the following words in the input mask: 0 \ 0 \ 0 \ 0 \ 0 \ 0 \ 0 \ 0 \ 0
Pretty simple and easy. Follow the example for download: Format date
Posted in Dates , Examples , Expressions , Forms | 1 Comment »
Tuesday, March 18th, 2008 |
At the request of the player Joao Cabrita developed this form of control point that applies to a fire station, more specifically to the needs of the reader.
It is a basic example, but with some more advanced details on what it is intended to make the control of entrances and exits of employees, verify that worked a 12 hour shift and add more hours worked and hours worked to less.
All this for a monthly report of attendance of each employee.
Download: Point
Written Consultation , dates , examples , expressions , forms , hours , reports | 9 Comments »
Friday, January 25th, 2008 |
Another easy example to do this is that we use when we have a database of customers and want to count the number of clients beginning with each letter.
That is:
Customer
Alberto
Ana
Manuel
Beginning with "A": 2 records
Beginning with "M": 1 record
See Example: Count Records
Posted Queries , Examples , Expressions , Forms | No Comments »
Tuesday, December 18th, 2007 |
This is a small example that demonstrates how we can do a running sum, ie, as seen in the bank statements for example.
For the total field we use the DSum function to calculate the previous value plus credit and subtract the debt.
To download the example click here
Posted in Dates , Examples , Expressions , Forms | 6 Comments »
Tuesday, January 2nd, 2007 |
This is a very useful application that uses a module to write a number in full. For example, we introduce the value 100.50 in a field and another field he writes in words the value in Euros (Hundred Euros and fifty cents).
Download: extensive
Posted in Examples , Expressions , Modules | 1 Comment »
