I am in the middle of making a Daily Production Report DB for my business & I have setup my db to record the daily output for each shift
I have setup 1 table & 150 fields within it to make the job abit easier. I need to do a part number search so my data control will place the searched for data into a dbgrid..
I've tried many ways & many places to find a multi-field search SQL cod ethat will work the way I need it..

I've tried the following code to no avail:

Private Sub Command1_Click()
grid.Data1.RecordSource = "SELECT Info.PartNumber1, Info.PartNumber2, Info.PartNumber3, Info.PartNumber4, Info.PartNumber5, Info.PartNumber6, Info.PartNumber7, Info.PartNumber8, Info.PartNumber9, Info.PartNumber10, Info.PartNumber11, Info.PartNumber12 From Info where Info.PartNumber1, Info.PartNumber2, Info.PartNumber3, Info.PartNumber4, Info.PartNumber5, Info.PartNumber6, Info.PartNumber7, Info.PartNumber8, Info.PartNumber9, Info.PartNumber10, Info.PartNumber11, Info.PartNumber12 = '" & txtTargetName.Text & "'"

grid.Data1.Refresh

Unload Me
End Sub

'
I am using a extbox for user input, if anyone would happen to know how I can help me fix this SQL delema I would be most apreciated.. Thank you..

------------------
~\*/~ Thank you....