Report

[stephendeloach via AccessMonster.com]

I am having troubles when I run a Report I have it set to ask who to Bill To.
Instead of typing the whole address is there a way I can just type the name
of the company and in the report it will put the Name and address of the
company? Thanks

 

[Rick B]

Sure. In your query (upon which the report is based) just put criteria
under the company name field. In that criteria put something like..


Like "*" & [Enter Partial Company Name] & "*"

This will cause only the matching company(ies) to pull to the query. What
data you print (company name, address, etc.) depends on which fields you
include in your report.

 

[stephendeloach via AccessMonster.com]

OK.. When i run the report now it has #ERROR in the fields that need to be
numbers and nothing in the Bill To. Right now I have...
[forms]![ParamForms]![Bill To]
"*" & [Enter Partial Company Name] & "*"

in the criteria. How can i make it to when the [forms]![ParamForms]![Bill To]
box comes up I can just type the company name and it knows what to put in...
Does that make sense? The problem I am running into now is when I delete the
[forms]![ParamForms]![Bill To] from the criteria, I enter the partial company
name and everything works fine.. except it is pulling every invoice from the
Date I entered... We have multiple invoices with the same Date that need to
be Billed to different companies..

here is what my query looks like..

Field: Date Rig
Bill To
Table: DIW RHC
DIW
[forms]![ParamForms]![Date] [forms]![ParamForms]![Rig]
[forms]![ParamForms]![Bill To]

"*" & [Enter Partial Company Name] & "*"

I dont even know if this will make sense or not.. Thanks for helping..

Sure. In your query (upon which the report is based) just put criteria
under the company name field. In that criteria put something like..

Like "*" & [Enter Partial Company Name] & "*"

This will cause only the matching company(ies) to pull to the query. What
data you print (company name, address, etc.) depends on which fields you
include in your report.

I am having troubles when I run a Report I have it set to ask who to Bill
To.
Instead of typing the whole address is there a way I can just type the
name
of the company and in the report it will put the Name and address of the
company? Thanks

 

[Rick B]

Please view your query as SQL and paste that here so we can see the actual
query. While your query is on the screen, select the View menu, then SQL
VIEW. Copy and paste it.

Thanks!

--
Rick B

OK.. When i run the report now it has #ERROR in the fields that need to be
numbers and nothing in the Bill To. Right now I have...
[forms]![ParamForms]![Bill To]
"*" & [Enter Partial Company Name] & "*"

in the criteria. How can i make it to when the [forms]![ParamForms]![Bill
To]
box comes up I can just type the company name and it knows what to put
in...
Does that make sense? The problem I am running into now is when I delete
the
[forms]![ParamForms]![Bill To] from the criteria, I enter the partial
company
name and everything works fine.. except it is pulling every invoice from
the
Date I entered... We have multiple invoices with the same Date that need
to
be Billed to different companies..

here is what my query looks like..

Field: Date Rig
Bill To
Table: DIW RHC
DIW
[forms]![ParamForms]![Date] [forms]![ParamForms]![Rig]
[forms]![ParamForms]![Bill To]

"*" & [Enter Partial Company Name] & "*"

I dont even know if this will make sense or not.. Thanks for helping..

Sure. In your query (upon which the report is based) just put criteria
under the company name field. In that criteria put something like..

Like "*" & [Enter Partial Company Name] & "*"

This will cause only the matching company(ies) to pull to the query. What
data you print (company name, address, etc.) depends on which fields you
include in your report.

I am having troubles when I run a Report I have it set to ask who to Bill
To.
Instead of typing the whole address is there a way I can just type the
name
of the company and in the report it will put the Name and address of the
company? Thanks

 

[stephendeloach via AccessMonster.com]

SELECT DIW.Date, DIW.[Invoice #], RHC.Rig, RHC.Equipment, RHC.Hours, RHC.
[Cost Per Hr], DIW.[Bill To]
FROM DIW INNER JOIN RHC ON DIW.[Invoice #] = RHC.[Invoice #]
WHERE (((DIW.Date)=[forms]![ParamForms]![Date]) AND ((RHC.Rig)=[forms]!
[ParamForms]![Rig]) AND ((DIW.[Bill To])=[forms]![ParamForms]![Bill To]));

Please view your query as SQL and paste that here so we can see the actual
query. While your query is on the screen, select the View menu, then SQL
VIEW. Copy and paste it.

Thanks!

OK.. When i run the report now it has #ERROR in the fields that need to be
numbers and nothing in the Bill To. Right now I have...

[quoted text clipped - 43 lines]