help designing an access database to track customer receipts?
439789
lol.. this is a tuffy... if i had more time i could definitely advice... maybe u should try posting this on forums.aapfree.com ... where the real programming pros are.
564823
You could build your own tracking spreadsheet (or find a template) or database within Open Office ( http://www.openoffice.org ).
881584
For a small business you could either simply use an excel sheet, where u divide up the columns you need and use the calculation symbols for ease of any calculations. You can sum up, subtract etc easily. Just use the help/office assistant in Microsoft excel.\n\nAlternatively use SQL database system, you can get a person trained in software to create an sql system for you which will be quite easy to use and help in costs and all other functions for your data.
251475
Microsoft has a a system called bcentral, you can visit thier site at bcentral.com. I am not sure about an ASP solution, but would love to find out.
665063
I'm not exactly sure what your question is.  I'm guessing you are talking about something like Accounts Receivable or Accounts Payables. Companies set up different accounts to keep track of each customer or supplier.  \n\nCompanies set up different Payable accounts for people who they owe money to, so they can determine how much they owe to each person and if it has been paid.  All the Payable accounts together add up to the amount owed to suppliers. It also makes it easier to keep track of expenses. \n\nLikewise with Receivable accounts, different accounts are set up to show which customer has made purchases, how much has been paid, and how much they still owe.  This is a good way to keep track of revenues.
1036335
you need to make 2 list such as your expenses(which is things you buy for your business, or your bills).  Be sure to keep all your receipts this will help you out alot.    This is anything you buy for the business.  The other is earnings.  Another idea is a file box to keep on file all your customers their addresses and how to contact them.  You need a carbon copy recepit book so you can keep track how much money you have made and if they have paid.  another list   you will need is credit  and debits.  if you have any other questions you can msg  me @ lil_4wheelin_rebel on yahoo messenger ... P.S.  I am a business major and accounting and did what you are doing for my boyfriend except it was a computer business so i might can help you out more
637825
MS Access environment\n\nYou must create a field in Table Teachers that uniquely identifies each teacher. It can be an Autonumber field.\nGiven this, each time you add a teacher, the software will give this record a unique number.\n\nIn Students Table, create a field with number Long Integer data type.\n\nGo to Tools>Relationships and set a one-to-many relationship between the 2 tables using these 2 fields.\n\nCreate a query with this 2 tables using the fields in table Students and only the fields in table Teachers you want to show (not the autonumber field)\n\nMakiavel
129230
Peachtree accounting has this feature, I use it, but it is so close to Quickbooks that it should have it as well.
187676
Your best bet would probably be a list of checkboxes to match each question.\n\nOnce all the checkboxes have been filled in then submit the form and all the information gets transfered to a database.\n\nDo this as a standalone webpage with a DB backend. Probably something like mySQL or SQL2k, SQL2003 would be your best bet as Access only supports 10 connections at a time and you may overload this if you have multiple people entering data at the same time.
489298
Are they legitmate charges to your clients? Were the clients billed?\n\nRemember there is lag time , look at your statements\nwhen you make a purchase, sometimes it doesnt show that it was processed until the next day, for several ones.\n\nOne of them is that the merchant forgot to batch out.\n\nDo you even know your only company policy?\n\nWhat didyou say to him or her when she submitted the receipts to your accountant?\n\nOr are you an employee looking for a way to get her fired or in trouble?\n\nWhy doesn't your company audit these transactions?\n\nWhy did your company accept the charges?
112245
Microsoft - Its called Access (Database)
716245
It sounds like there's a problem in your code, or in the database. It's hard to tell from the amount of detail given, but I'd say that the customer ID procedure isn't the issue...\n\nRawlyn.
1014131
look at Microsofts office downloads section. they have a lot of business related templates and such you could use that might help you out.
436027
The usual way to do this is to have 2 tables.  One table for your purchases (i.e. the items you are bringing into your inventory) and another table for sales (i.e. the items that are going out of your inventory).  The common link is a part number (i.e. some unique number to identify each item).\n\nYou need to load each item purchased and qty. into the "purchases" table and load each item sold and qty sold into the "sales" table.  If you purchase and sell the same items over and over you can just keep adding rows to your purchases and sales table.\n\nTo see what you have on-hand you make queries that sum up all the purchases by part number and sum up all the sales by part number.  You join these together and include a formula to subtract sales from purchases.  The result is what you have on hand.\n\nDoing it this way gives you a running history of what was purchased and sold.  You never have to change or replace your original data - you just let the system do the math to tell you what's on-hand.
151888
Sorry, I don't think I can help.  I can use a 50 field table in Access and create a 50 field form using the wizard.\n\nDoes the problem occur running the wizard locally instead of through the thin client?  If it doesn't, you probably need to report the problem to Wyse.\n\nOnly other thing I can suggest (not saying it will make a difference) is see if you have the latest service pack installed for Office - maybe there was a bug???
419258
Take a look a samples that are close to what you want at http://www.bplans.com/samples/sba.cfm
919441
Two SQL statements, which you can enter in SQL view in the Access query designer.\n\nIn these statements, col1 is the greater column, col2 is the lesser column, and table is the name of your table.\n\nSELECT col1, col2, (col1 - col2) AS profit FROM table\n\nFor the sum:\n\nSELECT SUM(col1) AS col1sum FROM table