Small CRM - Microsoft Access Forum - Computer Learning Zone


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Small CRM

Johan vd Westhuizen

4 years ago

I have created a small CRM database which includes a call log to customers and a car logbook to calculate my weekly and monthly distances for claims. The problem I have is that I need to look up starting km's, insert it manually and then add the distance to calculate the total distance per day, between customers and back home. Is there a way the starting Km's can be added automatically?

	Scott Axton @Reply 4 years ago
What is a KM? See All About Context Getting the data out or looking it up is only available for use if you have previously entered it somewhere else or it can be derived from other data.

	Alex Hedley @Reply 4 years ago
I'd assume Kilometre (km) (instead of miles)

	Johan vd Westhuizen OP @Reply 4 years ago
Yes it's km's

	Michelle Seidelin @Reply 4 years ago
There may be a way of doing this, like Kevin help me with Excel how to bring the starting total down to the if I understood your question correctly. Kevin may be able to help you

	Kevin Robertson @Reply 4 years ago
Is the starting KM the ending KM from the day before? If so, you could possibly use a DLast or DMax in the Default Value of the Starting KM field. If not more info is needed.

	Scott Axton @Reply 4 years ago
Richard built a mileage tracker in the Subforms video. That would be a good place for you to start.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View