i'm lost

[moose]

sorry but i just dont understand reports.
what i have is a table with many customers and a table with many products and what i want to do is generate a printerble report based on the input from the user. i.e. if the user enters JOE BLOGGS i want the report to show all the products for JOE BLOGGS.
I hope this is clear, please help

 

[simongallop]

You need to create a query which limits the data to JOE BLOGGS. Then create a report where the data comes from the query. Use the report wizard and it will give you a basic report of JOE BLOGGS

 

[moose]

thanks, thats where i'm going wrong

 

[moose]

i have tried to run a query for joe bloggs, but it gives me zero results also. i also get the message "TYPE MISS MATCH" I'M NOT SURE WHERE I'M GOING WRONG

 

[moose]

i have tried to run a query for joe bloggs, but it gives me zero results also. i also get the message "TYPE MISS MATCH" I'M NOT SURE WHERE I'M GOING WRONG

 

[moose]

i have tried to run a query for joe bloggs, but it gives me zero results also. i also get the message "TYPE MISS MATCH" I'M NOT SURE WHERE I'M GOING WRONG

 

[Rich]

Go to the Microsoft site, download Solutions, RptSmp97 and Qrysmp97 you will find a wealth of useful code and examples.
HTH

 

[Lisa S]

I am going to guess that your set up is a table for your products and a table for your customers and linked via a customer id field in the products table??

Therefore, when you create your query, you need to add both the customers table and products table to the query and add the customer name from the customers table and the other fields from the products table. Base your query criteria on the customer name field in the customers table.

Hope this helps

 

[moose]

i tried that Lisa but i just get the message "type mismatch in join expression"
any ideas?

 

[Donna Tunstall]

Hi :

That message means that the two fields you are using as your join are of different data types. Meaning, one may be of a text type and one may be of a number type. Go to the design of the tables and double check it.

HTH

 

[moose]

thanks Donna, i have checked both fields in both tables and they are both text fields but i still get zero results from the query.
the relationship is between "customer" which is a text field in "table customer" and "customer" in "table product" which is also a text field
the query uses field "customer" from "table customer" and "product", "product description" and "reference number" from "table product"
does this help at all?

 

[simongallop]

Start from scratch.

Goto Queries and click on New. Select the two tables that you are using. Click on field Customer in the first table and drag it to the corresponding field in the second table.

Now double click on customer from the first table, so your query will now show one field. Now look at the results. If there are no results then it means that you are not using the same customer name in both your tables. If you get TYPE MISMATCH then the field customer in the first table is different from the field in the second table.

If on the other hand your result shows some names then just add the fields from the second table that you want to see.