Replies

Hi Francois

“If you want a list of all items with number that have been sold for each one, create a new subreport based on a new total query end put it in the report footer.”

I tried this but could not get it working. I built a simple totals query on the products table, grouping by product and SUM of the Quantity, but this obviously give me totals for the whole table.

I could not work out how to link this query/subform to the rest of the report…

Cool! I got that working, thank you. I have now learned how to link the report and subreports!

Can i modify this to be able to list the various different products sold with their respective totals in the main form footer?? I.E. If i have sold 5 different products in the footer will be those 5 different products with their respective totals..

Charlotte.

Yes, you’ve got it in one when you ask about having moved to the subform!! There is no warning that the parent record has been saved.

I know by that point a user should not want to discard the record.. Would it be “normal” practice to offer that facility???

DSUM did the job perfectly…

I’m trying to do a count of the rows in the same listbox.. I’m tring to use DCOUNT but i think i am not referencing the listbox correctly??

DSUM did the job perfectly…

I’m trying to do a count of the rows in the same listbox.. I’m tring to use DCOUNT but i think i am not referencing the listbox correctly??

And it does! Thank you!

I am fairly sure this is an unrelated problem, as your suggestion works in a small test qry.

When i try to use the form/cbobox as the criteria in the report’s query, it tells me it does not recognise the criteria as a valid source. HOWEVER in a test query with very many fewer fields it has no problem.

Is it possible that on a complex query (several tables and a subcrosstabquery), it reports an error on the criteria, yet on a simple query it does not???

And it does! Thank you!

I am fairly sure this is an unrelated problem, as your suggestion works in a small test qry.

When i try to use the form/cbobox as the criteria in the report’s query, it tells me it does not recognise the criteria as a valid source. HOWEVER in a test query with very many fewer fields it has no problem.

Is it possible that on a complex query (several tables and a subcrosstabquery), it reports an error on the criteria, yet on a simple query it does not???

Doh!!! Thank you!!

I set up the row source ok…. and I have to admit i did not read (correctly) your binding the combo box to the ID field…. Now it works!!!!

Thank you again!!!

Doh!!! Thank you!!

I set up the row source ok…. and I have to admit i did not read (correctly) your binding the combo box to the ID field…. Now it works!!!!

Thank you again!!!

Hans.

Thank you for your time in replying. I am understanding what yousay, and think i became confused when i realised the source for the combo box would be different to that of the form.

So last step, would be to use an AfterUpdate event on the combo box, and use the recordset method? to collect the address etc data and insert it into the relevent text boxes..

Hans.

Thank you for your time in replying. I am understanding what yousay, and think i became confused when i realised the source for the combo box would be different to that of the form.

So last step, would be to use an AfterUpdate event on the combo box, and use the recordset method? to collect the address etc data and insert it into the relevent text boxes..

Ok, so am i trying to complicate things here??

Looking at it again, i guess i should do a lookup in the tblCustomers to retrieve the name and address etc. Then should i bind the form to a query source to save the invoice and invoice details to??

Ok, so am i trying to complicate things here??

Looking at it again, i guess i should do a lookup in the tblCustomers to retrieve the name and address etc. Then should i bind the form to a query source to save the invoice and invoice details to??

Hi. Could you not have a field in the comments table that hols the date and time the comment was added… Then look for the comment with the most recent date….

Hi. Could you not have a field in the comments table that hols the date and time the comment was added… Then look for the comment with the most recent date….