Hi all, Hope someone can give me a quick explanation as to how or what i need to do next...sorry but i thought this would be easier than it's turned out to be! I remember it differently the last time i made a database in works 97! Anyway, for a small business i have made a table with all the details required such as name, address, county, order product A, product B, email, notes etc. and can mail merge fine...half the job done for mail lables but how do i query the database if say someone phones up. This is quite possibly the stupidest question i've ever asked on here but hey ho! If I were to take their postcode to see their details (if they'd ordered before), what next? What, apart from the massive table i have built already, am i missing to finish the job? I've tried queries but they just bring up another screen that has loads of info on it and i just cant seem to find out where i type in something like postcode=PO99 9AL and then get one value returned!!!!! Please help my poor ignorance before i kill the computer =)

Although I have made many databases using Access I am not familiar with Works, so the best I can offer is the site below which is a Works database tutorial. Good luck. http://www.internet4classrooms.com/database_win.htm

Alternatives . http://www.aadconsulting.cjb.net/ezydata.html Ezy Data Freeware for Windows 3.1/95/98/NT/ME/2000 The Easy Way to Create Databases Ezy Data is a stand-alone application that lets you easily create relational databases for entering, storing, viewing and analysing data. You can also import data in a spreadsheet or other database into Ezy Data. The Query Wizard that helps you create and save SQL queries for use in your database. Ezy Data is easy and intuitive. Quickly create tables, fields and relations, and then drill down into all the tables, relations, and fields, and field properties in your database. You can view selected field properties, and create and delete tables and fields. You can also set indexes, create table relations, and edit other field properties. You can enter, view and analyze all your data in Ezy Data. The Data Definition Wizard automatically documents your Ezy Data database. New in Ezy Data Version 3.0 You can now create and individually name an unlimited number of Ezy Data databases. Import tables and data from virtually any source. Ezy Data 3.0 also includes two sample databases, business.mdb and personal.mdb, from which you can import a wide selection of pre-designed tables. You can now automatically compact and repair your databases. An Ezy Data database can be used natively in all versions of Microsft Access for full database capabilities. Download Ezy Data 3.0 (ezydata3.zip - 4.7 mb) --- http://www.liberum.org/features.html For Help Desk Administrators: Choice of using NT user accounts or a separate database for granting users access to the help desk runs on Microsoft IIS - no proprietary web servers easy-to-use menus for managing reps, departments, categories, priorities and statuses runs on with MS SQL or an Access database built-in reports for keeping track of problems, users and support reps configurable email messages easily customizable pages to fit your organizations needs

I knew dBASE fairly well, and I'm a whiz at Access, but I have no idea as far as Works in concerned.. Sorry..