rose dawsen's Discussions
Add data from previous record if blank
1 Reply
Started this discussion. Last reply by Richard Rost Oct 9.
rose dawsen's Page
Latest Activity
You could use the DMAX function to figure out the rate for the previous date thats less than the current rate.
MaxRate: DMAX("Rate","MyTable","Date
I have a table with "Date" and "Rate" fields. Not every record contains a value in the "Rate" field. is there a query that would insert the value from previous record in case the "Rate" field is null?
The sample table looks like this:
Date;Rate
200…
Comment Wall (1 comment)
- At 4:35pm on August 9, 2009,
Access Guy said…
- Hi Rose
Welcome to Access Developers.
Profile Information
- Rate your experience with Microsoft Access.
- This is my first database
- Explain why you answered that way and tell us more about your self and experience.
- access is good
About
Latest Activity
Well maybe this is a bit late (I have only just joined the site) but maybe somebody needs to do a bottom line analysis - that is how the company is being hit in the hip pocket. Just simply timing someone entering all of the information for each appl…
Badge
© 2009 Created by Access Guy on Ning. Create a Ning Network!
