Search results for query: *

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

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

Anyone have any easier solutions? Thanks Jon

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

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

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

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