question

Mal avatar image
Mal asked

date range incoming and out goind buildings.

I have an access table that has a list of portable buildings that are recieved and dispatched. Buildings are charged an amount over each month via two conditions. (1) secure storeage $6.25 (2) Unsaecure storage $3.00 Each building has a unique identy number and its easy enough to show a report that goes month by month. My problem is that I dont know how to work out a charge on buildings that are received or dispached part way through the month. Please help Mal

sql-server-2008
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

malpashaa avatar image malpashaa commented ·
You should provide us with more information (table structure, sample data and expected output) to be able to help you
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.