Hi John. I'm assuming that you just typed this in to the web site and didn't copy and paste it. Your function should be:

format(forms!getdaterange!endingdate,"mmddyy") & [code]

I don't think code is a reserved word in Access, but you never know. If you're not sure, best to enclose it in square brackets.

I need to know more about where you're using this to help you. In a query? "Calling the invoice number from the invoice itself" doesn't help me much. I need more details. Without seeing your database you have to be as descriptive as possible.

Reserved Words from the Glossary

Nice. See, you've got stuff in there even I haven't seen. LOL

You haven't memorised all 200 glossary items? Shocking :p

Richard sorry I had just typed the function in and just messed up on syntax. This function creates the invoice number that appears on the physical invoice to be sent to client. It is tied to an unbound field called "invno". As each invoice is generated this field is populated via the function "format(forms!getdaterange!endingdate....)" . What I am trying to do is to figure out how to get the invoice number either into the orders table or into a separate table so that a particular invoice can be recalled without having to know the exact day it was run. When I try to reference the invoice number on the invoice itself, it keeps saying that the field is not found. The only way I can get it to work is to create VBA code run at the end of each invoice. Is this the best way to handle this?
Hope this helps.

Yep. When the invoice is entered, I would create a text box on the form that has a default value set to that code. If that doesn't work, then you could make an AfterUpdate event for the InvNo field so when you type that in, it updates the other field.