Hi all. heres what im doing...
i do music and as a project im doing a chord search...
their a 4 different chords major minor diminished augmented....
so ive made 4 tables in excell with all my information on these chords....

how do i make a search box in access so i can type in
MAJOR C#
and it locate the major table and show me everything in the row c#

This is a sample of one of my tables
MAJOR
IDChord123

1CC E GE G CG C E
2C#C# F G #F G# C#G# C# F
3DD F# AF# A DA D F#
4D#D# G A#G A# D#A# D# G
*i want access to have a search function that i can type in MAJOR C#
or
MAJOR ID 2
I then want access to open up just row :::: Major ID 2 Chord C#

You want to use the 'Like' comparison.

So your SQL would looke something like
Select * from Songs where Music like '*Major C#*'