I am in need of having my current query cleaned up. I would like for this query to do the following: For every record in the FilteredData table select a corresponding record in the Mapping-new table where “PolicyNumFirst9 in the FilteredData table is = Pol Pfx and Serial in the Mapping-new table?? AND the AccidentDate in the FilteredData table is between the KRMS-ConPolEff and the KRMS-ConPolExp in the Mapping-new table. Once run this query should place all matched items in a new table called MappedData and all unmatched data in a table called NonMappedData the sum number of records in both the MappedData table and the NonMappedData table should tie out back to the FilteredData Table. As usual I am in need of a quick turnaround, working/portable code from Access to SQL and vice versa. Thanks.
## Deliverables
Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased.
## Platform
windows 2000
## Deadline information
As per usual I need a quick turnaround with this. And, as per usual I am willing to pay a bonus for good portable code that meets my time table.