Recent content by collectuer

  1. C

    Question Append/update Query

    Thank you, I think you are right much easier to add a new column and move all the data to one searchable table. Thank you for the help.
  2. C

    Question Append/update Query

    Thank you so much for the reply, I am having trouble with the SQL statement taking all the parameters I only get 2014- in the first field. Here is my SQL INSERT INTO tblTarget (tbltarget.lir, tbltarget.incdate, tbltarget.client, tbltarget.OTIS, tbltarget.Partb, tbltarget.rmt1...
  3. C

    Question Append/update Query

    If anyone could help me I would greatly appreciate it. I am trying to update numerous tables for a more effective search. My company has file numbers list as such 001 -1000. The issue I am having is that a new table was started each year (so I have 18 years of 001 etc..) and I want to simply...
See more
Top Bottom