General Filter Query

[Guest]

on ms excel you can run a filter the extract information with a "begins with"
filter, how do i do this in MS Access as part of a make table or select query

thank you very much

 

[Allen Browne]

Use the Like operator, with a trailing wildcard.

For example, you could find all records where the field begins with Microsof
by entering criteria of:
Like "Microsof*"

 

[Guest]

thank you this is great

Use the Like operator, with a trailing wildcard.

For example, you could find all records where the field begins with Microsof
by entering criteria of:
Like "Microsof*"