Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Merging 2 tables
Hello, I want to merge 2 tables to simplify a database. I wish to add into the first table some text from the 2nd table where an ID matches. But I don't want to append new rows or columns I wish to add the text into an existing text box on the record. e.g> Table 1 ID Name 1 Jon Table 2...- filterjon
- Thread
- Replies: 2
- Forum: Microsoft: Access Tables and Relationships
-
Profit and Loss Access Report
Hello all, I am considering using access to make a profit and loss report for the company I work for. I have the data available in a query but I am not sure if I can format a report so it lists the months in columns eg. Jan 2007 Feb 2007 Mar 2007 Sales Sales Sales Materials...- filterjon
- Thread
- Replies: 3
- Forum: Microsoft: Access Reports
-
Chart with zero values
Hello all, I am trying to create a chart in access using a query as the data source. A sample of the data is Lead Time Value 1 200 2 300 3 400 5 200 I would like to display a chart that shows the data including a leadtime of 4 with value 0 even though...- filterjon
- Thread
- Replies: 7
- Forum: Microsoft: Access Forms
