How do i fix this error " enter parameter value"?

[Joana Johnson]

I have two quarries one that gives me a list of book sales(customer, quantity, book number,date) and the other gives me a list of Book Numbers and their corresponding prices. I need to create a field in the first quarry that i mentioned that will gives me cost of each customers total order.

I started by using the design view and clicking on build. I input this equation:

quaryBookCost: [Quantity]* [Books Query]![BookPrice]

but it then asks me to "enter parameter value"

I can't seem to figure out where I went wrong any help you could give me would be great.

[NeoPa]

It's hard to tell from the little information posted. Typically, this message comes when there is something in brackets ([]) which it is unable to resolve.

As the named value is quaryBookCost, I would guess towards a simple mis-spelling of something, but it may be that the query [Books Query] doesn't even exist within your query. If it does, maybe it doesn't contain a field called [BookPrice].

I can't tell you what is mis-spelled without access to how all the items are actually spelled, but you should check them all out carefully.

[Moah Scout]

Wellcome to bytes!
As Neopa said, it may be due to the [Quantity] try to replace [Quantity] with [Sales Query].[Quantity].
If it still gives you that parameters error, then try your design from the Scratch