P
porky
I have modified the Order Entry database that comes with Access so that there
are more than one catagory of product in the sub form 'order details'. I did
this by creating a new table that is identical, apart from the table name and
field names, to the products table. i have got this to work fine and all the
data seems to work, until that is i try to run the invoice report. this is
fine until i add the new table to the query in order to add the fields to the
report to give me a complete invoice. the report displays a message 'no data'
closing report. if i turn off the no data 'event' i get report which give no
data regarding the order. if i run the query it is fine until i add the new
table. if i create a fresh query with the products table and the new table it
works fine, if i add the order details table it won't run. in fact it works
fine with any two of the three tables. any one know anything.
are more than one catagory of product in the sub form 'order details'. I did
this by creating a new table that is identical, apart from the table name and
field names, to the products table. i have got this to work fine and all the
data seems to work, until that is i try to run the invoice report. this is
fine until i add the new table to the query in order to add the fields to the
report to give me a complete invoice. the report displays a message 'no data'
closing report. if i turn off the no data 'event' i get report which give no
data regarding the order. if i run the query it is fine until i add the new
table. if i create a fresh query with the products table and the new table it
works fine, if i add the order details table it won't run. in fact it works
fine with any two of the three tables. any one know anything.