How do I format a field in Access 2000 to collect the same data fo

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to collect income on the same client for multiple years? How do I do
this without wiping out previous year's data?
 
I need to collect income on the same client for multiple years? How do I do
this without wiping out previous year's data?
Click to expand...

By using Access as it is designed - a relational database!

You need (at least) TWO tables - a table of Clients, and a table of
income, related one to many. The client info would go in one table,
and a ClientID and the income information in the second one.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Collection via Email 1
Is there a checkbox option for collecting data in Access? 1
How to work with many tables all have the same fields? 3
Formatting the Text in a Access Data Collection Email 5
Creating scientific data collection form 7
Email ACCESS data collecting from Mac to Win! 7
Should I switch from Excel to Access as the data source 4
averaging data 4

Back
Top