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 actually removed it to make the chart display correctly. Is that what links it to the report?

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]...

Ok...I understand. Thank you

In another report, I created charts and used shift_ID to sort which worked fine. I don't understand the difference with this chart. I am a beginner with access. Curious about the click event on the menu. It didn't pull up the report and not sure how the VBA plays a role in the report because...

I can't thank you enough. Although I don't comprehend what is going on behind the scenes to make it work, I am thrilled it works. I just can't believe it has to be so complicated to sort.

How was that achieved?

Yes... The report section works fine, I just can't get the chart to sort the same way.

Here is the file

I would like the Deputy Totals by Month (Datasheet View) to be sorted by Shift_ID which should list the shifts in the order of Days, Afternoons, Midnights, SRU, STU, OTD. The only way I can make it work is without setting the order by Shift_ID and it ends up in alphabetical order. I have to...

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 just learned about crosstab querys. I was able to make it work.

Didn't display formatting correctly, but I think it's understood what I am looking for.

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...

Thank you...The multifield index worked great.

I tried the method above...all it did was sort by the first digits and not the whole expression.

I have another problem involving unique numbers. I have a table named tblCitations with Citation_ID set as an auto number and the Key Field. I also have a citation_number field and Citation_Date field. I didn't set the citation_Number field to no duplicates because eventually the numbers will...

Thank you for the response Pat. I will try your method when I get home.

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.

DLookup worked like a charm...Thanks again