Calculations/Forms/Tables (1 Viewer)

[Mile-O]

Doesn't do anything - just lets those helping, if they don't know already, get an overview of how the question has developed over the dual posting.

 

[Nick Toye]

Sorry I didn't mean to confuse anyone, I just thought that my question had become relevant to forms so I put in that forum. My mistake. I think that i'm nearly there now, i've learnt quite alot about access. I just don't understand how I update the query.

 

[Nick Toye]

Is it in the SQL View?

 

[Nick Toye]

Can anyone tell me how to update a query from a form, Once i've done that I think we can put this string to bed, as thats all the help i'll think that i'll need for now.

Thanks very much

 

[Rich]

Base the form on the query

 

[Nick Toye]

So when I do that, it prompts me for information that I have put in for user interaction.

For example, my query asks me for a beginning date and end date, and a customer name. If you read my previous posts you can understand my predicament.

It doesn't behave like a form.