L
liverpoolbonnie
Hi - I need to set up a database based on an estate agents, for a
project in college. I need the user to be able to click on the
switchboard to find houses that are for sale within a certain price
range and in a certain location. I know how to use the switchboard and
how to use parameter queries.
I need to know how to prevent houses which have already been sold from
appearing on the list. What I would like to do is to have a field for
house sale date, which, when completed, will automatically put that
house into a different table.
Will it be an append query following by a delete query?
Any advice would be greatly appreciated.
project in college. I need the user to be able to click on the
switchboard to find houses that are for sale within a certain price
range and in a certain location. I know how to use the switchboard and
how to use parameter queries.
I need to know how to prevent houses which have already been sold from
appearing on the list. What I would like to do is to have a field for
house sale date, which, when completed, will automatically put that
house into a different table.
Will it be an append query following by a delete query?
Any advice would be greatly appreciated.