I am familiar with excel more than access, but I was wondering i
someone could just point me in the right direction in terms of wha
program to use.

I need to design something for a real estate sign install company

Ideally I would like to do the following

A sheet or table with all the agent names, offices, cell numbers
etc...

When I receive the order, input the order into database of some sort.
Each order could have anywhere from 1 to 5 different items on it, wit
different quantities for each one.

Once the order is complete, there are only 2 things that can happe
with that order, we go put a sold sign on the sign, which is a charge
or we remove the sign which is free, but we need to know the date w
remove it.

There will be a couple thousand entries in a years time.

The hardest part so far for me whether it be excel or access is to lin
a billing system. So when we put the order in, and can generate th
bill. The problem is 2 fold.
1. A sold sign can be added on to the job anytime later
2. Some agents are billed to the individual, and some agents are bille
as a whole office.

3. We only bill once a month in our industry.

Any type of insight would be very helpful.

Thanks

Jos

--
jhahe
-----------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...fo&userid=2359
View this thread: http://www.excelforum.com/showthread.php?threadid=39301