Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cost Per Square Feet

Status
Not open for further replies.
tmcneil

tmcneil

Technical User
Nov 17, 2000
294
US
Hi all,

I have a database with lease information. I have the square footage of each record (lease) in one table and costs per month in another table. The tables are related based on a common Lease ID. The second table has costs associated to a company service code. There could be three service codes to one lease, hence, a one to many relationship. In understand the concept of getting the output I need, Cost/Area to get the Cost Per Square Foot. How should I attack this problem?

Thanks
 
Status
Not open for further replies.

Similar threads

xwb
  • Locked
  • Helpful tip
Performing VBA operations in other languages
Replies
1
Views
233
strongm
strongm
Katto
  • Locked
  • Question
VBA permutation of arrays
2
Replies
22
Views
454
Katto
Katto
renigar
  • Locked
  • Question
Excel VBA: Copy selected text from word, paste in excel at selected cell, 1 line per row 1
Replies
19
Views
340
renigar
renigar
msc121
  • Locked
  • Question
calling a sub in personal.xlsb from with in a VBA module
Replies
3
Views
174
strongm
strongm
brajcool
  • Locked
  • Question
on PowerPoint Presentation, Change the each Bar color of Excel Linked Graphs as per their value
2
Replies
20
Views
157
brajcool
brajcool

Part and Inventory Search

Sponsor

Back
Top