Creating report for totals

[BRZ-Ryan]

I dont think it's working right though. I have calls in my table for December and these are not listed in the report.

[June7]

I created some December records (copy/paste November records and changed date). They show up in report.

You can provide your latest effort for analysis.

[BRZ-Ryan]

Here's how I have it laid out now. The only thing is the first set of data is blank, and the data I want is shown below, is there a way to fix this? I also want to have November 2013 appear in the header because the report will be by month. I also just need to work on the formatting part which is easy. Thank you again for your efforts!

Is there a way I should format my tables to make reporting easier?

[June7]

Want to provide latest version of db?

[BRZ-Ryan]

https://www.dropbox.com/s/t9t6qpukce...xTracker.accdb

[ellisthomas86]

I would recommend you to go with some automated tools to get the things resolved with. Some call tracking softwares or apps. And remember go for some advanced cloud based version of apps that will resolve the issues in automated form.

[June7]

You might find this of interest http://office.microsoft.com/en-us/te...010206879.aspx

Can't download the db now, will try again tonight.

[June7]

November is missing the 4:01 PM - 5:00 PM time slot.

Do you want every month to have every time slot?

That will require a dataset of all possible month/timeslot combinations.

The time slots are not listing chronologically. Should be saving the ID in Calls instead of the slot description. Or use placeholder zeros: 04:01 PM - 05:00 PM

[BRZ-Ryan]

Yes, but I don't think there should be a bracket for an hour, it may have been left out of an existing bracket

[June7]

Its record 4 in Time Slots.

My question and solution still valid.

Also, correction to my earlier post. If you want the time slots to sort chronologically, use 24-hour clock time: 16:01 - 17:00

[BRZ-Ryan]

Ok I understand, I thought the time slot was missing from my timeslots table, but it's there and it's a record for just that hour.

Yes, every month should have every slot, and blank or 0 in the placeholder as applicable.

I think I am missing the whole fundamental principle behind ID's and values. If I link the ID to a field, how do I make it (textbox,combobox,etc) display the value, instead of ID, in a particular field linked to the ID?

[June7]

With queries. Join tables in query to make all related information available for use in output.