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

In the grander scheme of things it sounds more like you are trying to record
and store things than to compute and analyze things. That implies that a
database would work the best. That being said if your skill set is a little
thin on the database side of things then Access will be a uphill battle. If
you feel comfortable enough with Access then go for it. If not then I guess
Excel will have to do. It is possible in Excel but it is not the optimal
solution.
--
HTH...

Jim Thomlinson


"jhahes" wrote:


I am familiar with excel more than access, but I was wondering if
someone could just point me in the right direction in terms of what
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, with
different quantities for each one.

Once the order is complete, there are only 2 things that can happen
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 we
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 link
a billing system. So when we put the order in, and can generate the
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 billed
as a whole office.

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

Any type of insight would be very helpful.

Thanks

Josh


--
jhahes
------------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=393017