MATCHING TWO DATABASES

[Guest]

Help!!!

I am trying to match two databases. I am trying to create a database of
real estate clients to match the price database. For example: I have
clients A, B, C, D, C, E, F, G, H, I, J, K interested in properties that
range between $1,500 - $2,500. I would like to create a database that
automatically match the clients with the properties and/or indicate what
clients match the property prices. Help, please!!!

 

[John Vinson]

Help!!!

I am trying to match two databases. I am trying to create a database of
real estate clients to match the price database. For example: I have
clients A, B, C, D, C, E, F, G, H, I, J, K interested in properties that
range between $1,500 - $2,500. I would like to create a database that
automatically match the clients with the properties and/or indicate what
clients match the property prices. Help, please!!!

You're not looking for a *database* - you're looking for a *query*.

Short jargon lesson: In Access, a "Database" is a container, a .mdb or
..mde file containing multiple Tables, Forms, Reports, Queries and
other objects. A Table is where you store information; for example you
would have a table of Clients, and a table of Properties, and probably
other tables. A Query is what you would use to link two tables.

Here's a possible design: construct two tables, Properties and
Clients:

Properties
PropertyID <autonumber, Primary Key>
Address Text <e.g. 123 Maple Blvd.>
City Text <e.g. Scranton>
Description Memo
Price Currency
<any other fields to describe the property itself>

Clients
ClientID Autonumber Primary Key <don't use the name as key>
LastName Text
FirstName Text
<contact information, e.g. phone>
PriceRangeLow Currency
PriceRangeHigh Currency

Fill these two tables with your properties and the client information.

To find which properties are within each client's price range
construct a new Query in the queries window; add the Properties and
Clients table and select whatever fields you want to see. On the
Criteria line under the Price field in Properties put

= [Clients].[PriceRangeLow] AND <= [Clients].[PriceRangeHigh]

And... if you've got real estate going for $1,500 to $2,500 let me
know where!!!

John W. Vinson[MVP]

 

[Immanuel Sibero]

And... if you've got real estate going for $1,500 to $2,500 let me
know where!!!

Iceland, maybe?

Immanuel Sibero

Help!!!

I am trying to match two databases. I am trying to create a database of
real estate clients to match the price database. For example: I have
clients A, B, C, D, C, E, F, G, H, I, J, K interested in properties that
range between $1,500 - $2,500. I would like to create a database that
automatically match the clients with the properties and/or indicate what
clients match the property prices. Help, please!!!

You're not looking for a *database* - you're looking for a *query*.

Short jargon lesson: In Access, a "Database" is a container, a .mdb or
.mde file containing multiple Tables, Forms, Reports, Queries and
other objects. A Table is where you store information; for example you
would have a table of Clients, and a table of Properties, and probably
other tables. A Query is what you would use to link two tables.

Here's a possible design: construct two tables, Properties and
Clients:

Properties
PropertyID <autonumber, Primary Key>
Address Text <e.g. 123 Maple Blvd.>
City Text <e.g. Scranton>
Description Memo
Price Currency
<any other fields to describe the property itself>

Clients
ClientID Autonumber Primary Key <don't use the name as key>
LastName Text
FirstName Text
<contact information, e.g. phone>
PriceRangeLow Currency
PriceRangeHigh Currency

Fill these two tables with your properties and the client information.

To find which properties are within each client's price range
construct a new Query in the queries window; add the Properties and
Clients table and select whatever fields you want to see. On the
Criteria line under the Price field in Properties put

= [Clients].[PriceRangeLow] AND <= [Clients].[PriceRangeHigh]

And... if you've got real estate going for $1,500 to $2,500 let me
know where!!!

John W. Vinson[MVP]

 

[tina]

i was thinking maybe north pole - do you suppose it would be cheaper to buy
in summer when the ice pack has melted (hmm, a liquid asset?), rather than
in winter when there's something to actually stand on? <g>

And... if you've got real estate going for $1,500 to $2,500 let me
know where!!!

Iceland, maybe?

Immanuel Sibero

Help!!!

I am trying to match two databases. I am trying to create a database of
real estate clients to match the price database. For example: I have
clients A, B, C, D, C, E, F, G, H, I, J, K interested in properties that
range between $1,500 - $2,500. I would like to create a database that
automatically match the clients with the properties and/or indicate what
clients match the property prices. Help, please!!!

You're not looking for a *database* - you're looking for a *query*.

Short jargon lesson: In Access, a "Database" is a container, a .mdb or
.mde file containing multiple Tables, Forms, Reports, Queries and
other objects. A Table is where you store information; for example you
would have a table of Clients, and a table of Properties, and probably
other tables. A Query is what you would use to link two tables.

Here's a possible design: construct two tables, Properties and
Clients:

Properties
PropertyID <autonumber, Primary Key>
Address Text <e.g. 123 Maple Blvd.>
City Text <e.g. Scranton>
Description Memo
Price Currency
<any other fields to describe the property itself>

Clients
ClientID Autonumber Primary Key <don't use the name as key>
LastName Text
FirstName Text
<contact information, e.g. phone>
PriceRangeLow Currency
PriceRangeHigh Currency

Fill these two tables with your properties and the client information.

To find which properties are within each client's price range
construct a new Query in the queries window; add the Properties and
Clients table and select whatever fields you want to see. On the
Criteria line under the Price field in Properties put

= [Clients].[PriceRangeLow] AND <= [Clients].[PriceRangeHigh]

And... if you've got real estate going for $1,500 to $2,500 let me
know where!!!

John W. Vinson[MVP]