Recent content by Jaydee-187

From my form, I am able to enter information into four unbound boxes which saves the data to a table named tblFeedingActual. How can I delete the last record row entered (sorted by ID) from my form. I am using access 2010 and vb. Thanks

Thank you for your help and concern on the last post. It didn't get off on the right note so I managed to solve it with a little help from one of the guys from this site. Much appreciated!

Hi, I would like this code to generate the report without entering print preview mode nor trying to print. Thank you Private Sub cmdPreview_Click() On Error GoTo Err_Handler '******************Filter report to a date range Dim strReport As String Dim strDateField As String...

Hi, From my db frmWhatDates, I can give a parameter of the dates for a report but it shows all the days for that period with each amount. Is there a way to show the total or sum rather than each amount. Thanks

Ok, Thanks for the suggestion. I have uploaded my db and if you have the time, I'd appreciate your help.

Hi, Attached. I have also attached my DB. Thank you. ------------ I've just uploaded my db and managed to filter the results of the query by date but would like it to show the total of each food for the week. Could you help me?

Hi, Thanks for your response. This was a snap of a crosstab query and not the table. Would you be able to help?

Hi, Yes this is a cross tab query.

Hi there! I would like to generate a report from a query based on a range selected by the user from a form. I have entered one weeks worth of data to test it out as shown in the picture attached. I have various food types (listed in the columns) and would like the report to sum of amount of...