Search results

OKay, driving myself a bit nuts with this. I am trying to get a total count of rows from a query on my tickets, Each ticket has a date and an ID number SELECT tbl_ticket.ticket, tbl_ticket.entrydate, Count(tbl_ticket.[entrydate]) AS [Row Count] FROM tbl_ticket GROUP BY tbl_ticket.ticket...

I am trying to set up a form that gives me the following style of output for my ticket system and I can't seem to figure out what I am doing wrong. 0-30 31- 60 61- 90 etc Ticket Catagory 1 Ticket Catagory 2 Ticket Catagory 3 Ticket Catagory 4 I...

Okay, I have tried hiding the subform's footer but it still shows up. I am trying to hide the bottom part in access 2010 where it has the search bar and record count. How can I hide this?

Okay I am having issues with my query for my database Private Sub Combo2_AfterUpdate() DoCmd.RunSQL "INSERT INTO tmp_ticket (ticket) SELECT ticket FROM [tbl_ticket] WHERE assigned LIKE ""Me.Combo2""" End Sub It sort of works, it trys to append 0 rows! What I am trying to do is get...

[Solved] Storing SQL Queries to a table I can't seem to find it and this has to be the last bit of stuff I need to get my Database up and running for my boss using an EXE front end. What I am trying to do is something similar to what I did for my reports I have a table with the following...