Creating Query to pull info from Linked Excel Spreadsheet

  • Thread starter Thread starter Marilyn Myers
  • Start date Start date
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.
 
I will try this tomorrow when I go back to work. Thank you so much for your
help and Happy New Year!
Marilyn
 
P.S. I might need some help building my query, I will let you know after I
build those tables. Thanks Again.
M
 
Back
Top