Viewing 8 posts - 16 through 24 (of 24 total)
Access doesn't like it. What is the meaning of
max(x1.Subaddeffdate) Subaddeffdate
with no comma?
And where is table dbo defined?
Robert
January 18, 2005 at 9:27 am
Okay, I just got the word. No attachments!
Let’s try this. I have the following 2 tables:
January 17, 2005 at 3:01 pm
Thanks for responding.
This almost works. When I insert this change the query does return a...
January 17, 2005 at 5:08 am
It happened again with my new database! I don't suppose you could post your sample db?
December 20, 2004 at 9:37 am
Phil,
I created a query that calls my 2 queries and that is working just fine in Access. Don't think it will work in VB though.
David,
It's strange. Access seems to be working...
December 20, 2004 at 8:25 am
Thanks for posting the code, David.
When I tried to save it, I got thrown out of Access. I was careful to change the '[' around the 2 SELECT statements to...
December 20, 2004 at 7:59 am
Sounds interesting. I'll give it a shot, although I have never created a view. I assume you can create views with Access (although I'm planning to switch to Sql Server (dumb,...
December 19, 2004 at 7:54 pm
Viewing 8 posts - 16 through 24 (of 24 total)