Member Avatar for jammiedude

Could anybody help me with a problem i have?

I have a budget sheet and a list of incomes and expenses, and i need to be able to search a specific column and look for a certain text like general ( which may be displayed as "Commission - General") then copy the figure from column C. the trouble is that it needs to search the whole of column B looking for any cells that have the word "General" in.

Thanks
James

  • 2 Contributors
  • 1 Reply
  • 98 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by K.Vanlalliana
Member Avatar for K.Vanlalliana

You can Search particular word from any of the Column by using Searc string like this:

Sql="Select * FROM YourDatabaseName WHERE ColumntoSearch like '" & Trim(txtSearchTextBox.Text) & "%' ORDER BY toSearchColumnName"

So, the above code will Search whatever you write within the textbox 'txtSearchTextBox.Text'.


I hope this will give you an idea

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.