B
Brian1956
I would like to be able to search by keyword, and be able to print them out
in Chronological or Skills format.
in Chronological or Skills format.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
dsc2bjn
I have a resume database used prior to hiring employees. The "resume text"
is dumped into a memo field. I allow three keywords to be used to search the
"resume text", as an OR statement. I order the records returned by the
earliest employee candidate entered into the database using the "resume
submission date".
A lot depends upon how your database table(s) is/are set up. If you have
"Skills" in a table linked to the employee table (so that one employee could
have multiple skills), then you could search the "Skills" table for keywords
by creating a query with Skill1, Skill2, Skill3. You could sort the data by
whatever date field you have in your employee table or by a date field in the
Skill table.
If your skills are stored in the employee table as Skill1, Skill2, Skill3,
you only need to create a prompt for each field (using and OR statement) and
order by whatever date field is appropriate (employee hire date or skill
achieved date).
is dumped into a memo field. I allow three keywords to be used to search the
"resume text", as an OR statement. I order the records returned by the
earliest employee candidate entered into the database using the "resume
submission date".
A lot depends upon how your database table(s) is/are set up. If you have
"Skills" in a table linked to the employee table (so that one employee could
have multiple skills), then you could search the "Skills" table for keywords
by creating a query with Skill1, Skill2, Skill3. You could sort the data by
whatever date field you have in your employee table or by a date field in the
Skill table.
If your skills are stored in the employee table as Skill1, Skill2, Skill3,
you only need to create a prompt for each field (using and OR statement) and
order by whatever date field is appropriate (employee hire date or skill
achieved date).
B
Brian1956
Thanks. This is very helpful.
dsc2bjn said:I have a resume database used prior to hiring employees. The "resume text"
is dumped into a memo field. I allow three keywords to be used to search the
"resume text", as an OR statement. I order the records returned by the
earliest employee candidate entered into the database using the "resume
submission date".
A lot depends upon how your database table(s) is/are set up. If you have
"Skills" in a table linked to the employee table (so that one employee could
have multiple skills), then you could search the "Skills" table for keywords
by creating a query with Skill1, Skill2, Skill3. You could sort the data by
whatever date field you have in your employee table or by a date field in the
Skill table.
If your skills are stored in the employee table as Skill1, Skill2, Skill3,
you only need to create a prompt for each field (using and OR statement) and
order by whatever date field is appropriate (employee hire date or skill
achieved date).