Recent content by AWirsching

I've made a few adjustments...

Good afternoon, I have started back at it again and am a little confused and need help understanding. So dat the beginning I tried and tested various text boxes and combo boxes which then supplied data to my table with an ID number. Well, at times I've had to delete rows and with multiple...

Hey guys, thank you both for the help. yesterday I was super busy but I'm back at it today. I'll let you know how it goes. Thank you both so much for the help. This is actually my first Access Report I've ever done...

No worries. I just keep trying it. I'm grateful for all/any help!

I deleted it. Same error appears this time only once. Again the answers provided are wrong.

[Operational AAR/Summary] is the main table. I was able to get everything running until I had to add the date parameter.... Upload file is too large. =(

I received the following error when trying the form again after correcting the SQL This popped up several times (obviously something with the queries), however this time when it brought up the report, several of the answers appeared however they were incorrect. This is the SQL: SELECT...

Apologies, I see what I did! Let me fix this.

Oh ok. Well, that worked with the query. When I went back to the Date Parameters form, I received the following error:

First off, what is QBE? I switched the Where to go before the Group By and all I did was cut and paste but now I have another error message: SELECT Count([Operational AAR/Summary]![Investigation Type]) AS NoKnocks, [Operational AAR/Summary].[Op Date] FROM [Operational AAR/Summary] Where...

SELECT Count([Operational AAR/Summary]![Investigation Type]) AS NoKnocks, [Operational AAR/Summary].[Op Date] FROM [Operational AAR/Summary] GROUP BY Count([Operational AAR/Summary]![Investigation Type]), [Operational AAR/Summary].[Op Date], [Operational AAR/Summary]![Investigation Type] Where...

SELECT Count([Operational AAR/Summary]![Investigation Type]) AS NoKnocks, [Operational AAR/Summary].[Op Date] FROM [Operational AAR/Summary] GROUP BY Count([Operational AAR/Summary]![Investigation Type]), [Operational AAR/Summary].[Op Date], [Operational AAR/Summary]![Investigation Type] HAVING...

SELECT Count([Operational AAR/Summary]![Investigation Type]) AS NoKnocks, [Operational AAR/Summary].[Op Date] FROM [Operational AAR/Summary] WHERE ((([Operational AAR/Summary].[Op Date]) Between [Forms]![Date Parameters]![Start Date] And [Forms]![Date Parameters]![End Date]) AND (([Operational...

I have multiple queries because I need to gather the sums of various questions. Some questions are simple yes no while others are out of a list of items, such as the one pictured above.