Creating Query to pull info from Linked Excel Spreadsheet

M

Marilyn Myers

First of all, I am new to Access 2007. I have a profile table and a linked
table from Excel. I built a query to pull information on amount owed for
current month. The heading for the field in the excel spreadsheet is: Jan-09
Amount Owed, Feb-09 Amount Owed, etc. I need the info for the current month
to show me all the tenants that have a balance due greater than 0. Can
someone point me in the right direction or do you need more info. Thanks in
advance for any help you can give me.
 
M

Marilyn Myers

I will try this tomorrow when I go back to work. Thank you so much for your
help and Happy New Year!
Marilyn
 
M

Marilyn Myers

P.S. I might need some help building my query, I will let you know after I
build those tables. Thanks Again.
M
 
S

Steve

Happy New Year to you too!!

I forgot to include the field "UnitID" in TblUnitRent. Please add that field
when you build the tables.

Steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top