Search results

Thanks for your reply. I have tried this and while it's the closest I've gotten it's not enough. It's still just grouping by the months of the 2 parameter dates. I'm looking for something that will also show the months in between. For example, there is a rental period of 2 years, the user wants...

Hi Rexes, Thanks for replying. The user will be inputting maybe 01-01-06 as the start date and then 31-06-06 as the end date, and it calculates the total rental due for that entire period. But the user wants it to segment the rental into montly sections, for example, to see a total for Jan06...

anyone?:confused:

I have a table which lists rentals, all have start/end dates and a rental fee p.a. I want to query this table to show rentals that are effective for any part of 2 dates, [Enter Start Date] and [Enter End Date]. The purpose of this query is to calculate rental income between these 2 selected...

what a mess I've gotten myself into! It's all so complicated now, what started out as being a small database to replace an excel spreadsheet... I'm not comfortable enough to remove the workgroup files. I'll try to work around it... would this be possible if I create a new blank db, import...

Is it ok to delete existing workgroup files or are they needed for anything else? I've run into similar problems and want to start over regarding the security and I've split the database and tonight will create shortcuts from each users PC. But in the meantime I'm still getting workgroup errors...

Yes, I guess what I'm really asking is how would you calculate it for the start/end months, if for example the lease began on the 15th of the month, and in a 30-day month there would be 16 billable days... Sorry for not specifying & thanks for your help! :o

Hi there, I have a table with a start date and an end date for a leasing database. The lease has an annual fee, but I want to calculate what's that worth for each month of the duration of the lease. Is this possible through a query? :confused: I was going to store this data, but having read...