NEED HELP

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to put together a simple Acces Data base. Been stuck on one thing
for 6 hours. That is I have one field that has my price, next field is buyers
price.
I need the profit field to calculate the differnce between buyer's price and
my price.
I want it to perform that simple calculation evertime I put those values in
there.Please help.Thanks Demetrius
 
Possibly. In Excel you only have spreadsheets, in Access you have tables and
queries. Tables are used for hard data. Queries are used to collect, sort
and filter hard data from tables and transient information like calculated
fields.

John... Visio MVP
 
John Marshall said:
Possibly. In Excel you only have spreadsheets, in Access you have tables and
queries. Tables are used for hard data. Queries are used to collect, sort
and filter hard data from tables and transient information like calculated
fields.

John... Visio MVP



So I will have to run a query evrytime I want to know my profit for each property?
Click to expand...
I won't be able to see it in a table glance?Thanks
 
John Marshall said:
Possibly. In Excel you only have spreadsheets, in Access you have tables and
queries. Tables are used for hard data. Queries are used to collect, sort
and filter hard data from tables and transient information like calculated
fields.

John... Visio MVP



I have an inventory of about 40 properties, with about 10 fields(Ie address, bedroom bath,price,buyer's name ect..) So it maybe better to just use excel? I like the fact that I can attach my contracts to each property in Access. I don't think that can be done in Excel correct? Thanks for your time.
Click to expand...
 
Once created, you can use the query like an Excel spreadsheet or you can
create a form based on the query and view the information through the form.
The form can set up to look at individual records are multiple records.

John... Visio MVP
 
Back
Top