LearnerAnu
New Member
Hi,
I am very grateful to the members of this forum. It is because of your guidance and help i have been able to finish a big part of the project.
I need some help with the query.I have an excel sheet on which i take input of a user using dropdown. The data to dropdown comes from access. In my database i have a maintable and a place table. The maintable has a placeid as foreign key. In the drop down i am getting the placename. I need to use the two tables to filter data in database and retrieve the data to suit user's requirement.
my query is:
Src = "Select * from MainTable, PlaceTable where MainTable.PlaceId = PlaceTable.PlaceId and PlaceTable.PlaceName = " & V_PlaceName
the V_PlaceName is the variable that stores the value from dropdown. The query only gives my headers back from the database and no data associated.
Kindly help.
I am very grateful to the members of this forum. It is because of your guidance and help i have been able to finish a big part of the project.
I need some help with the query.I have an excel sheet on which i take input of a user using dropdown. The data to dropdown comes from access. In my database i have a maintable and a place table. The maintable has a placeid as foreign key. In the drop down i am getting the placename. I need to use the two tables to filter data in database and retrieve the data to suit user's requirement.
my query is:
Src = "Select * from MainTable, PlaceTable where MainTable.PlaceId = PlaceTable.PlaceId and PlaceTable.PlaceName = " & V_PlaceName
the V_PlaceName is the variable that stores the value from dropdown. The query only gives my headers back from the database and no data associated.
Kindly help.