Search in column of table, Return entire row of data

[elephant97]

I have a table with 8 columns and about 5,000 rows. I need some method by which to search column 1 for a specific date (the column is unique, only one date will exist). Once the search finds that date, I need to store the information in the remaining 7 columns in that row. I know I can accomplish this in Excel with a For/Next loop and the .Cells method, but how do I do this in Access??

 

[Norie]

Is this 'table' an Access table?

And what do you mean by 'store the information'?

You could use a query to pull the data you want from a table by setting the criteria for the 'date' field to the date you want.

Perhaps you can explain further what you're setup is?

 

[elephant97]

Yes, this is an access table. When I say store the information, I want to report the information on the row in a report.