| Recent Answers |
 |
|
2008-09-06 Using MS Access - Build a financial Databace: Are you asking to contract for my services in designing this database? If so, I would be happy to quote you a cost for doing so. But that's beyond the scope of a site like this. If you want a quote...
|
2008-09-05 Using MS Access - Records in form: It sounds like you are editing an existing record instead of creating a new one. I generally use different forms for adding new records and editing existing ones to prevent that from happening. Or I require...
|
2008-09-05 Using MS Access - adding to fields in a query: You can use an IIF to add the /. For example: field1 & IIF(IsNull(field1) And IsNull(field2),"", IIF(Not IsNull(field1) AND Not IsNull(field2),"/",,"") That should only show a slash if both are not...
|
2008-09-05 Using MS Access - MS Access - Formula text boxes storing results in table: You don't. As a general rule we do NOT store calculated values. You can use the same expressions you have to calculate those values wherever you need to display them. Only the components of the calculation...
|
2008-09-05 Using MS Access - criteria: Hi Erdinc, The datatype for the underlying field [HemProNo] should be numeric if its a non-aphunumeric value, and secondly the field [Text104] should contain a numeric value if the underlying fields...
|