New db for contacts and invices

[waterdamage]

Hi, I’m new to access and I have read through a couple of books but still struggling.


If I make a tables with my info in it say customer details, use quires to sort display and print that info. Now is that query saved and do I end up with lots of query’s (hundreds.) Or
I’m assuming that that query is then lost (don’t know the correct term) and the only way of getting this info back is make a query asking for the same info criteria.


I’m thinking of an invoice made up of info from a contact table
My invoices are very simple I only supply labor and materials and don’t have set prices for ether, so I need to insert prices that I input and text that I input Both will be manually inputted although some sort of auto text that can be edited to make each invice individual would be nice

Hope this makes some sort of sense, can any one point me to some key areas that I can read up on

thanks

 

[Wiz47]

Hi, I’m new to access and I have read through a couple of books but still struggling.


If I make a tables with my info in it say customer details, use quires to sort display and print that info. Now is that query saved and do I end up with lots of query’s (hundreds.) Or
I’m assuming that that query is then lost (don’t know the correct term) and the only way of getting this info back is make a query asking for the same info criteria.


I’m thinking of an invoice made up of info from a contact table
My invoices are very simple I only supply labor and materials and don’t have set prices for ether, so I need to insert prices that I input and text that I input Both will be manually inputted although some sort of auto text that can be edited to make each invice individual would be nice

Hope this makes some sort of sense, can any one point me to some key areas that I can read up on

thanks

I'd just create create a simple Form for the input of the information, then use a permanent query that is the RecordSource for a Report (invoice) based on what you enter into the form. Each invoice will be different and based on the new record information. Then you'll be able to print the invoice and have a permanent record of the sale.

 

[Dreamweaver]

Hi, I’m new to access and I have read through a couple of books but still struggling.


If I make a tables with my info in it say customer details, use quires to sort display and print that info. Now is that query saved and do I end up with lots of query’s (hundreds.) Or
I’m assuming that that query is then lost (don’t know the correct term) and the only way of getting this info back is make a query asking for the same info criteria.


I’m thinking of an invoice made up of info from a contact table
My invoices are very simple I only supply labor and materials and don’t have set prices for ether, so I need to insert prices that I input and text that I input Both will be manually inputted although some sort of auto text that can be edited to make each invice individual would be nice

Hope this makes some sort of sense, can any one point me to some key areas that I can read up on

thanks

Steve what I sent ya will do that in that you create a client, invoices for client, recieve payments, and you can add bills,
Give me a call after 7pm and I'll go though it if the Getting started doc dont help ya all those Items will be in the next project so I can move the data but will get ya going for now.

mick