Search results

I have a table containing information about traffic tickets written including the date written. I want to create a table to enter the month/year and number of days worked in that month. How do I bring all the tickets written by a particular officer for a specified month and divide the total...

I have a report that is filtered by Month and Year from an unbound form. The report filter's correctly, but the chart on the report displays a summary from all the records. I tried placing the following in the criteria of the chart query [Forms]![Summary Month and Year CriteriaInput]![Month]...

I have a chart that I can't figure out how to sort by my key_ID field. My other chart sorted properly, but this one won't. If I upload my database, would someone try and see what is wrong...spent a whole day messing with it and can't make it work.

I am trying to create a simple report that will display an officer name and then fields for each month of the year with the total record count for each month. I want it displayed as follows: Jan Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec Name 12 15 15 20 15...

I am having trouble sorting an expression smallest to largest in a report. I used the Val function in the query and it works, but can't figure out how to make it work inside the report. Example of the expression result is 625 ILCS 5/ 11-601(b) which is the Illinois statute for speeding.

Couldn't find an answer to this problem. I am having trouble getting a textbox on a form to display more than 255 characters. The table field "Description" is set to memo and all the data is displayed in the table, but my textbox which has a control source set to =[OffenseSection].[Column](3)...

Does anyone know of a way to prevent access from listing the chart columns alphabetically? I tried looking for a way to custom sort, but can't find a way to do it.

I can't find any posts regarding a syntax error in Transform statement. I believe it is the chart that is causing the problem. I can view the chart in report view, but if I change is to print preview, I receive the error. Anyone have any experience with this problem?

I'm having a hard time wording the question. I have a main form with a sub form. The goal of the database is to track citations. The main form displays each deputy and the subform displays all the citation info. The problem is when the person entering the data enters a citation under the...

Can't seem to find an answer to this. I want my sub form to always go to a new record when I navigate through the main form's records. I am able to go to a new record with the open event and a macro, but it's a one time event.

I have a report for citation totals. I grouped the report into Shift (Days, Afternoons and Midnights), Rotation (Yellow, Green and Red) then into Citation type (Non-Traffic and Traffic). Everything is grouped correctly and I am getting the correct record counts for each citation type under...

I have a textbox with the following control source, =[OffenseSection].[Column](5). Is it possible to add column 6 also with a space between? I can't seem to get it to work

I have 2 cascading combo's in datasheet view that work as planned except for the second combo goes blank after you click off the row and re-appear when you click on the row again. Anyone else experience that?

I have an unbound form with two combo boxes (one for badge number and the other for last name) and two text boxes with a date picker. Everything was working fine until I put the two text boxes in and now it isn't returning the correct information. I'm sure I have something wrong in the query...

I am using an unbound form with 2 combo boxes for query criteria. I would like the boxes to be clear for the next use, but I can't find the right event to trigger that. They either clear to early and the query doesn't run or they won't clear at all.

I can't figure out why this DCount returns #Error... =DCount("Citation_ID","qryMonthlyTickets","[Offense] = 'Speeding'") I placed it in the control source of a textbox.

I have a textbox on the top of my report that displays the current Month/Year=Format(Date(),"mmmm"", ""yyyy") but I would like it to display the Month/Year of the query/criteria results.

Is there a way to change the Year(Now()) function in the criteria to begin October 1st instead of January 1st?

I am having trouble using the DCount function to return the number of records from two different fields. I am able to return records from one field. Not sure of the correct syntax for multiple fields.

I have an employee table with a checkbox that is checked if they are currently employed. I can't figure out how to only display the employees that have the checkbox checked