query giving the wrong results

[steve111]

hi,

I have a query called " invoice report query"
there is a field in that query called " cdescription" this is from the table "order details "

in that field there are 5 results called "bulb" and "capacitors"
where I run the query all I get is " capacitors " in all 5 results

the invoice number when the query is rum is " 1 "

could you please have a look and advise that have I got wrong

thanks
steve

 

[Minty]

There appear to be several tables missing, which is weird as the query still runs?

 

[jdraw]

Steve,

Your naming convention --with embedded spaces, and colons - must be a nightmare when programming. I agree with Minty that tables are missing. What exactly did you remove from the database?

 

[steve111]

hi ,

i have attached more tables and forms for more information

please open the form sales orders goto record 185

you will see a field called " cdescription" i select the partno but the description goes into the order details table
the order number for that record is 670013002

please select open invoice at the top of the form and then enter the order number in the find order field at the top

This is where i put the cost etc in the second form ( free input )

if you now run the query as before or the report i don't get the what i need

yes this is my first project like this so i know next time not to use spaces etc

thanks
steve

 

[steve111]

hi

more information . if I remove the invoicedetails table from the query the cdescription is correct but I don't know how to solve it with that table in the query

steve

 

[steve111]

HI ,

edited this post so last post is still open

steve