Database Counter

D

Daniel

This may be easy for some of you guys but I'm not sure out to work it.

The database I have include date/location/item number etc etc.

What I'm trying to have the counter do is to figure out how many lines there
are that have unique date and location.

example. two lines with the same date and same location would count as 1.
two lines with same date but different location would count as 2.
two lines with different date but same location would count as 2.

The data contains hundreds of lines which more than what I want to read
through.
I would need to figure out the count within a date range that i entered.

I would be greatly appreciated if anyone as any constructive input.

Thanks~
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top