Find partial data for multiple fields in a query

[lmdillon]

Hello--I have a table I inherited that was not set up properly. This table has several date fields and in each date, a program name and physician name are listed. I need to make tables for each program for all of the date fields.I have used the criteria: Like * & [program name] & *The above works well for one field. However, when I pull down another date field (for a separate date range), no rows will be produced for the table.Any ideas or suggestions would be appreciated. Thanks!

[ranman256]

if date is 1st use LEFT, MID, functions..

vDate = Left([field],10)
vProgram = Mid([field],11)

or find the separators
I = instr([field]," ")
vDate = mid([field],I +1)
vProgram = Mid([field],I-1)