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!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by filterjon

  1. filterjon

    Merging 2 tables

    Thanks Leslie - I will have a play with the set bit of the inner join. p.s. I love your disclaimer!!!!
  2. filterjon

    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...
  3. filterjon

    Profit and Loss Access Report

    Anyone have any easier solutions? Thanks Jon
  4. filterjon

    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...
  5. filterjon

    Chart with zero values

    Thanks for your replies. I'll start coding and let you know how it goes. Cheers Jon
  6. filterjon

    Chart with zero values

    Thanks for the reply... but, In this case, there is no leadtime of 4. In effect I am trying to show the leadtime data over an equi-distant scale and not squash the data together. If I do a scattergraph the data looks right, i.e. the bottom axis has equal time divisions on it. However, this...
  7. filterjon

    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...
See more

Part and Inventory Search

Back
Top