My conclusion also. I was trying to use existing queries but I'm afraid I have to start from scratch which is not a bad idea. I don't have the time to commit to it right now but I learned something from this exchange and I really appreciate your help and your patience. Thank you.
Okay, here are the two queries:
Query 1: qryMeetingMembersNOTComing_crb
SELECT DISTINCTROW qryCompaniesMembers.CoID, qryCompaniesMembers.CoName1, qryMeetingALLRegistrantMembers.StatusID
FROM qryCompaniesMembers LEFT JOIN qryMeetingALLRegistrantMembers ON qryCompaniesMembers.CoID =...
Here is what I have now.
SELECT qryMeetingMembersNOTComing_crb.CoName1, StatusID
FROM [qryMeetingMembersNOTComing_crb]
UNION SELECT qryMeetingMembersNOTComing_crb.CoName1, StatusID
FROM [qryMeetingALLRegistrantMembers_NOreminders];
I changed the qryMeetingMembersNotComing_crb to query on the...
Tried that and the error I get is:
The specified field 'B.CoName1' could refer to more than one table listed in the FROM clause of you SQL statement.
I think I know what the problem is. The query "qryMeetingMembersNOTComing-crb" is a 'find unmatched query' so the CoName1 field is in the query...
I do have the correct query names. I entered your code, Remou, and got the error
"The specified field ‘CoName1’ could refer to more than one table listed in the FROM clause of you SQL statement."
So I added the query name to the CoName1 field. Ran the query and it was having trouble with...
I am trying to create a simple union query and I keep getting a syntax error in the from clause. This is my SQL statement:
SELECT CoName1, StatusID
FROM qryMeetingMembersNOTComing-crb
UNION SELECT CoName1, StatusID
FROM qryMeetingALLRegistrantMembers-NOreminders;
Can anyone tell me what I am...
It is not turned off, but I can't make the calendar go back to August 20, which is when this occurred. I don't know if that is a wise idea anyhow. The only restore point is yesterday.
I have already removed a junk mail email filter update, not sure if it is the same one. There are only two remaining updates for Microsoft Office - KP907417 OTKLOADER and Service Pack 3. They both say they cannot be removed.
There is also the compatibility pack. Would there be anything in...
I have a problem with good mail going in the junk mail folder. I had the same problem twice before and a technician determined that it was caused by a Microsoft junk mail update. He knew never to apply that update to my PC. My junk mail filter was working very well. Now a new techician...
It's the sticky key problem! Never thought to look at the keyboard. This was on a co-workers computer. And indeed there was a little glob of gooey stuff between the keys. Thank you all so much for the help.
When I type a hyphen in Word or Outlook, it changes to an equal sign and a hyphen (=-). Is this an autocorrect problem or is something else going on. I have checked the autocorrect list and there is no entry like that. Anyone have any suggestions?
My problem didn't go away. I thought it was too good to be true.
Thanks for the comment on the Google toolbar. I think I'll avoid it until I get some resolution on this browsing problem. It's a pain in the neck to constantly have to hit that refresh button.
I resisted the reset. I don't like to lose my customized settings. But it seems to have resolved the problem, although it did take away my Google toolbar. Maybe that was part of the problem.
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.