It took me a minute to figure out the alias thing, but now it totally makes sense. I worked through all the code on my large tables and it all came together just how I wanted it. I can't thank you enough for this solution. I will hale you as a god to my friends.
r937,
That is a great idea and I totally understand the logic, but I haven't been at this for long and maybe I typed it incorrectly. When I try to run or save it comes back saying
"Syntax Error in date in query expression 'Regist #'."
I will paste some of my sql in here so you can see if it's...
Ok here is the problem.
I have created a database for someone and it contains x amount of records on one table. There are many fields that were left blank to fill in as we go. So they have been actively entering info into some fields for certain records at their office, but i have also been...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.