Currently 1349 dates (records)ending at 12/31/2010. I will let you know how this turns out....probably tomorrow. Would I run the code from a control on a form somewhere or would I run it from the VBA code? Table name is "Dates tbl", field in table (only 1) "Date".insert the number into the new document (eg insert the number into a Custom Document Property that can then be referenced via a DOCPROPERTY field in the document) .increment the number in the text file, then close it.Start and emptable.enddateleft join (Select Hoursworked.empid, Dateofwork, Sum(Hours) As Hoursworked from Hoursworked Group by empid, Dateofwork)hwon Hoursworked.empid=emptable.empidand hw. I do not uderstand the rationale to add records (dates) which may not have other unique (and meaningful) fields to a table. Michael Red if puforee only uses it for the porpus as i explaned there is no need for other fieldsin my date table i have othe information about the date but when i create the dates all i put in is the date afterward i add othe information like holdays date office closed that is determed and entered by mangement and on a later date the way i enter dates to my table is i have a digits table 1 field digitid form 1 to 999999I still would like to know / uderstand this.
Here is the above Invoice Sample created by this template You can download my Free Microsoft Word Invoice Template from Here as a zipped (compressed) file Save this file to the root of the C drive C: (i.e.
I can right click each one individually and choose update field, but that could take for ever once there are a lot of fields.
Hi zebo51, To update all the fields, simply do Ctrl-A then F9.
FWIW, you could get rid of the '\* MERGEFORMAT ' without doing any harm to the fields.
If you want to, press Alt-F9 to expose the field codes, then use Find/Replace with '\* MERGEFORMAT ' as the Find string and nothing for the Replace string.