I'm new to this forum. I have tried looking for a solution in the net but have not been able to find one. I have the following SQL string in access(SQL View option):

select * from TableName(M200601) where ....

The portion I'm interested in editing is the date: "M200601". This is hard coded right now into the query. I would like for the year and month to be recognized automatically preceded by an M and passes into the Select string. Is there a way to do this?

Thank you for any input provided!

Create a control in which the user selects the month and year they want to view and plugs it into a field, say fldMonth, fldYear; or a fldDate if you keep them combined.

table_name = "M" & fldYear & fldMonth
or
table_name = "M" & right(fldDate,4) & left(fldDate,2)

Create your query in VBA as:
"SELECT * " & _
"FROM " & table_name & " " & _
"WHERE ..."

Should work I think.

Edit: Can also use listboxes to select the Month/Year.