Help with creating query or report. Not sure which one or how.

[christinenicole]

A little background info:
My company uses Access for work orders. We are a retail maintenance company and we receive service requests for door repair, plumbing, locksmiths, GC, and electrical. We get the service requests from the home office of popular retail stores. We aren't just a company who has workers and we send them out. We have one database for the work history where we type up work orders under the store name and another that has a list of all of our technicians. We recently switched to Google maps and Sharepoint to find a tech. The girl who set up the database is no longer there and I taught myself the basics but don't know how to do everything. I learn quick though with help =).

I don't know if I have to make a new database, query, or report. So I need help with that.

So basically, I am trying to make it easier to find techs. I want to be able to search one technician to see a list of jobs they have done for us. Our process now is to go to our map, type city, click whether its door repair, locksmiths, etc.. then find the nearest tech. The problem I keep coming across is that the tech may only be good as a last resort or we haven't used him much. We like to send the same tech out if possible too. Our new employee made a new work history with Sharepoint (Im not to sure how that all works either) and then we have our old work history (which was pretttttyyyy full). So I'm finding myself going into our old history, going into the store's table, then to the column for store's id, text filters, contains, and I type the store # to see how many times we have been out. Then I scroll over to see who we sent out. LIKE WOW! Too many crazy steps.

Is it possible to connect the work history with the technicians database to show jobs done by a certain tech? Also to have it automatically update when we put a new work order in. I also don't know how that would work having two work histories. ALSO does anyone know if there would be a way to incorporate that with Google Maps??

HELP PLEASE!! =)
Let me know if I left out any details needed to answer.



Much appreciated

[ranman256]

yes, this can be done.
you can store locations in a field, and google maps will open it.
all reports should be created with queries.
you can also use forms so users only have to point and click to get what they want.
the work history table can connect with tech table on the common field. I hope youve learned basic query building and table relationships.

but everything you want can be built.