Show all records in month

[Hawaii80]

I have a date field w/drop down calendar on table called disbursements. I then have a portal on a reports for disbursements showing records related by said date. Problem is the only dates that show in the portal are the dates actually entered on the disbursement table, for example if someone input 3/1/2008 then only records of 3/1/2008 show in portal. What I want is for the portal to show all days within a month, not just the day entered into the date field. Any suggestions on how to calc this in a portal?

[AHunter3]

You need a different table in which every single day exists as a record and every day has only one record. Then within the portal to each of those dates, you put the field or fields of the actual appointment table (wherein each record means an actual scheduled event on a date, and not every date necessarily has appointments), and the two tables are related by date.

[Hawaii80]

Hi AHunter I do have a table for the date it's called disbursements. On the disbursements table there is a date field, each date does have it's own record. User goes to disbursements table enters date and other relevant information, record now created. The report is a line item by date, in each line item is a portal. If the line item date says 3/1/2008, then only records matching that in the portal show up, even if there are records in the disbursements table that are dated say 3/2/2008, 3/10/2008 etc.

[Hawaii80]

In an effort to understand what you are explaining AHunter, I'm explaining my scenario a bit more because I'm confused.

 

I have a table called disbursements, (this is for a property mgmt database). When someone pays their rent, accounting goes to disbursements, enters check amount, date received etc.

 

Then, I have another table called commissions. On that table accounting enters the total amount, (based upon disbursements for a particular month) to cut a check to the agent. Accounting enters among other fields, date check applied to, (very important because this is the relation to the disbursements table date). I then have a report layout that displays each check cut to agents and a portal next to each date which lists each disbursement that should be related, (within same month) to the check within the portal. The reason this is structured this way, is that accounting needs to know when they cut a check for the month to the agent, what are the individual disbursements related to that total check that fall within the same month.

 

There may be several different dates 3/1, 3/2, 3/5, etc... in the disbursements table. However, the only records showing in the portal are if the date applied to is the exact same date as the disbursement date.

 

I hope I'm explaining this better, as the more I talk about it the more confused I'm getting.