I want to come up with a report for an old record collection.....First of all which fields could i use and data types?......need pseudo code(VB) for generating report that prints all the records with all the records made by the same artists on one page aswell as the number of records by each artist.....can someone help?

I think you've started to answer your own question there - you're correctly starting by loking at what data fields you'll need on the output.   I can't advise exactly what you'll need but you should be able to work it out from knowing how your final reports will appear ... you'll need a field for each column on your final report unless it can be calculated from other fields, and you should always have a unique id / reference number key too.  That way, you'll easily be able to handle issues like (example) two copies of the same record in the collection.

As regards field types, you need to think of the type of data held in each and think is it going to be a whole number, a number that can have decimal parts, a piece of text or just a piece of data to be held.   That will then tell you that the data should be an integer, float, text or blob type respectively.   Thinking about the maximum range of the value will tell you whether it should be a tinyint, a bigint or something in between ...

Thanks...I think i have a handle on it now...Just needed some support i guess...

---