What is wrong with the database?

[Lou_Reed]

In this database there are two things that I cannot understand. The TotalMiles and TotalDays are listed as 0 in the RentalOrders form. I clearly followed your instructions and created them as you suggested as shown:

=[MileageEnd]-[MileageStart]

=[EndingDate]-[StartDate]



They both show zero when in form view yet I know each RHS component has a value other than zero.

Also, after a couple of initial forms are advanced only then does the Tax Rate of 7.5% show up. It is not on the first form (or the second) for RentalOrders.

I believe that I put that in only once when in the RentalOrders table, I put in a default value of 7.5%.

The TotalDays calculation in the RentalOrders form is actually made in the RentalOrders table. Thus just putting TotalDays with RentalOrders table as the Record source and TotalDays as the control source works.

It does not work in RentalOrders table and form for TotalDays. The TotalDays value is seen in the RentalOrders table data datasheet view, but it does not transfer to the RentalOrders form. I am unsure as to why.


Thanks again for all of your help.


R,

Lou Reed

[June7]

Okay, this is an issue I seem to remember encountering when first migrating to Access 2010.

Instead of referencing the field names, reference the textbox names:

=[Text42]-[txtMileageStart]

=[txtEndDate]-[txtStartDate]

[Lou_Reed]

That seems to work. There is one issue, however. On one of the 6 entries the car of rented out and returned on the same day. By the calculation that you have shown that would mean is was rented for zero days, not 1 day which is actually the case.

I know of no auto rental company that lets a customer have a car for just one day (with the same day as both check out and return) and charges you for 0 days or no charge at all!

So in some case such the one mentioned above there must be at least one day of rented use. How is does that change the equation; assuming it does change the equation.

Thanks in advance.

R,


Lou Reed

[June7]

Then always add 1.

=[txtEndDate]-[txtStartDate] + 1

[Lou_Reed]

Okay, you still have my database from yesterday. So why did the tax rate (7.5%) fail to show up on the first two records. It shows up clearly in the remaining 4 records.

I believe that you would say because in RentalOrders table the 7.5% tax rate only starts showing on the records 3-6. That is true.

I believe that I entered it only once in the design view of the RentalOrders table and that should have been sufficient. Why it missed the first two records in the RentalOrders forms is my question? It is on the last four records.

Thanks in advance.


R,


Lou Reed

[June7]

You set the DefaultValue property for TaxRate in table. DefaultValue only works for new record entry. If you set this property after records where created, the field will not be populated unless you type in the value.

BTW, the Categories table is not a fully normalized data structure. But if this is what the tutorial instructed, guess will have to go with it.