Retail Calendar - Just Google It.

There is an adjustment evey few years to get that extra day back.

This calendar is very specific and is in use by virtually all retail...

Hi - Actually this isn't a very specific use of a tally table for one customer.

This is called the "Retail Calendar" and is used by pretty much every retail business...

I work in somewhat of a skid row area of Los Angeles. We have several buildings with a secure fenced parking lot.

I would like my employer to sponsor a...

I am now 63 and have been working at this particular job for 7 years with a chair that won't adjust, a desk where my keyboard is way too high...

I changed the below update:

UPDATE dbo.InvoiceHeader SET dbo.InvoiceHeader.[Open] = 1 from dbo.InvoiceHeader INNER JOIN dbo.InvoiceOpen ON dbo.InvoiceHeader.Invoice=dbo.InvoiceOpen.Invoice  WHERE (((dbo.InvoiceOpen.[Type])='I'))

I eliminated the InvoiceOpen type field so I didn't need the...

Thank you.  Yes a suggested alternative to the process is most welcome.

No an invoice is never reopened.  If it is paid with a bounced check, etc (it happens) they do...

Sorry - last part of question.  INVOICE is indexed in both tables.

Thank you so much for being there for me.

Statements to set all invoices to zero (closed):

UPDATE dbo.InvoiceHeader SET dbo.InvoiceHeader.[Open] = 0

WHERE (((dbo.InvoiceHeader.[Open])=1))

this took 6.46 minutes - when I removed the...

Thank you.  That's the part that worries me.  Is my stuff floating around in some temp db waiting for me to do something?  And if so, what? 

Note - this...

Thanks both of you.  I actually know where the physical files are.  What troubles me is that after updating the file size and the date modified don't change. 

In Access...