If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access 2003
I have a field in one form that is calculating the difference in days between
two other columns. 1. Can I write the same expression in the table? How? ( in the table I don't have the values from the form for the same field and I can't run a query or a report ) 2. It is possible to have a macro or something, to search records and display in a different form ( or warning ), only values between "minus 10 and 5"? Thank you all for support. ( I don't know VBA ) |
#2
|
|||
|
|||
Access 2003
"ed the beginner" wrote in message
... I have a field in one form that is calculating the difference in days between two other columns. 1. Can I write the same expression in the table? How? ( in the table I don't have the values from the form for the same field and I can't run a query or a report ) 2. It is possible to have a macro or something, to search records and display in a different form ( or warning ), only values between "minus 10 and 5"? Thank you all for support. ( I don't know VBA ) There's no need to store the difference between the two columns, because that can always be calculated whenever you need it. Storing calculated values, when they are solely dependent on other fields, is generally a bad idea, because it opens the door to subsequent updates that may render the calculated value incorrect. I suggest you create this as a calculated field in a query. Let the query do the calculation, base your form on that query, and bind the control on that form to the calculated field. It would be easy to run a second query on that query to return records that have values between -10 and 5 in that calculated field. -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) |
Thread Tools | |
Display Modes | |
|
|