Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Custom Query Syntax Question

Status
Not open for further replies.
Guest_imported

Guest_imported

New member
Jan 1, 1970
0
I'm creating a database that allows the serch of records. There are 2 different searches, 1 allows users to view the records by the 'Type' of the record. The other allows a string search to search the records by 'TitleName'. Is there a way to allow this on the same page? When I click 'Edit' in FP 2000 to put in the string for the custom query, I have this in there to be able to search by 'Type' but I don't know how to also allow the search by 'TitleName'. This is what I have there:

SELECT * FROM "StuDev: Resource Database" WHERE Type = '::Type::'

Is there anything I can do? Suggestions? Thank you!
 
Status
Not open for further replies.

Similar threads

serino
  • Question
Help with a Query. 1
Replies
13
Views
425
strongm
strongm
combo
  • Locked
  • Question
'Wrong property setting' message in query 1
Replies
2
Views
3K
combo
combo
TheresAlwaysAWay
  • Locked
  • Question
Union query provides different reslt than when summing the combined queries individually 1
Replies
12
Views
767
TheresAlwaysAWay
TheresAlwaysAWay
Moss100
  • Locked
  • Question
Append query dropping leading zero 2
Replies
4
Views
713
Andrzejek
Andrzejek
JimStrand
  • Locked
  • Question
Crosstab query - returning 1 record per week instead of 1 record
Replies
1
Views
581
JimStrand
JimStrand

Part and Inventory Search

Sponsor

Back
Top