Stu @ M Developments

iTrader: (12)

I am trying to do some form of database to list my products in.

It needs a few titles such as:

Item cost
Item sale price
Paypal Fee
Profit.
Etc Etc...

And then ideally the ability to list each product alphabetically or via the column of my choice, such as "Profit"

I am sure this is reasonably easy to do, but sadly, i lack teh skills. Can anyone help me out?

-scar-

Database or spreadsheet Stu?

Either is fairly easy and I did a simple one for John Taylor last year with the very same info on it.

Stu @ M Developments

iTrader: (12)

Whatever is fastest and easiest for me to get on with ASAP Paul. I dont really know the difference as far as this job goes. Pros and Cons?

Sunil_FiestaRS1800

iTrader: (1)

I would do this using microsoft Access. Put all your products in a table and then you could create reports or queries to pick out any info you want.

If you wanted to be even cleverer you could create VB program to link with the database and hold customer info , product info, supplier info etc.

Then you could know who has bought what at a touch of button. See how much you owe suppliers, if you put invoices through system . It could also be setup to print invoices, print on cheques to pay suppliers. Basically could be tailored to do whatevev you wanted.

Stu @ M Developments

iTrader: (12)

Sounds a great reason to use Access then.

Shame i dont know how to.

foreigneRS

easiest for you to start with would be a spreadsheet in excel i suspect as you probably have that but maybe not other db software

in excel, once you've filled your columns all you have to do is Data > Sort and then choose which column you want to sort by

i think it really is that simple, but maybe i'm misssing something?

EDIT: you can always export to Access or other later on

Davie

Access is the way forward for this.

If no-one else can help you out, i'll have a go at it for you.

Sunil_FiestaRS1800

iTrader: (1)

If you have Microsoft Access on your machine i could create a database for you and give you quick run down on how to input the data and create queries from the data.

The great thing about using Access rather than excel is its much more powerfull and can be added to easily to hold customer info , supplier info etc.

Although saying that , if you dont want to build on this in future then excel will be the easier option to do what you want now with least hassel.

CossieRich

iTrader: (1)

You have email

Stu @ M Developments

iTrader: (12)

I have Access and Excel on all my machines. So whatever is easiest i guess.

Sunil_FiestaRS1800

iTrader: (1)

If you want me to knock up a quick database for you to have a play with i can, as it will only take me a few mins.

Will need to know exactly what fields you want in the products table and what sort of calculations if any you want to do on any of the fields.

Will also need to know if your running Access 97 (yellow key) or a later version as they arnt totally compatible.

Stu @ M Developments

iTrader: (12)

You have Mail Sunil.