Reply to thread

Message: [QUOTE="John W. Vinson, post: 6656298"] I'm not sure why it's working in one place and not the other, but do be aware that DATE and YEAR are reserved words (for the builtin date/time functions), and that Access can get confused. Consider using 'tbladageinventoryusage900report.[Date] with the square brackets, or (better) renamimg both fields. -- John W. Vinson [MVP] Microsoft's replacements for these newsgroups: [URL]http://social.msdn.microsoft.com/Forums/en-US/accessdev/[/URL] [URL]http://social.answers.microsoft.com/Forums/en-US/addbuz/[/URL] and see also [URL]http://www.utteraccess.com[/URL] [/QUOTE]