Remove the "Enter Parameter Value"

[ziad alsayed]

dear all

i am using access 2010.
if i open my report it give me the dialog " enter parameterValue". i need the report to open normaly without asking me any condition.

i ma still new in access, i dont know how i add it , i succeeded to remove from my Query but form the report i coudln't.

appreciate any help.

 

[Norie]

Sorry I don't understand, I though GeneratorCapacity was a field in the RentalFleet table?

That SQL seems to indicate you have a table called GeneratorCapacity.

 

[ziad alsayed]

dear Norie

i have four tables in my database
GeneratorCapacity which is in one to many relationchip with the rentalFleet table ( the rentalFleet table has one of its fied named Generator Capacity which loopup value from the GeneratorCapacity Table)
RentalFleet is in one to one relationchip with EngineSerialNumber
also RentalFleet in one to many relationchip with the Invoice Table.

My report is prepared from Tables GeneratorCapacity and Invoice table

 

[ziad alsayed]

dear Xenou<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
i tried your suggestion by using a query and i had no problem.i agrree with you the problem is in the Report itself.<o></o>
<o> </o>

 

[Norie]

ziad

How exactly are you doing this 'lookup'?

What's the expression you are using?

PS Did you test xenou's idea on the query the report is based on?

 

[ziad alsayed]

dear Norie

yes i tested Xenou Idea and i replied.

as for the Lookup it is a normal Lookup from table.

PS: the report was working perfectly , i just dont know what i did a save

 

[Norie]

ziad

I know you replied, I was just wondering if you tested the query that the report is based on or not.

As for the lookup, I assumes it's the usual DLookUp?

Can you post the expression?

 

[ziad alsayed]

dear Norie

below is the SQL View of my query

SELECT Invoices.[Engine S/N], Invoices.[Account Nb], Invoices.Customer, Invoices.[Invoice Number], Invoices.[Invoice date], Sum(Invoices.Amount) AS SumOfAmount
FROM [Rental Fleet] INNER JOIN Invoices ON [Rental Fleet].[Engine S/N] = Invoices.[Engine S/N]
GROUP BY Invoices.[Engine S/N], Invoices.[Account Nb], Invoices.Customer, Invoices.[Invoice Number], Invoices.[Invoice date];

i did't understand how the above is related to my problem.
i prepared my report through the report wizard by using two table the GeneratorCapacity and the Invoice table.

 

[Norie]

There is no field or table with the name GeneratorCapacity in that SQL.

 

[xenou]

It's something in the report, not the data source for the report ... Try checking filters, field names (?). Not sure. If the report isn't too complex, copy it and remove items one at a time until you've simplified it enough to find the problem child.

 

[Norie]

ziad

Did you not get my PM?