Fixed it!
The data fields in one of the two tables had fields set to "number" instead of "text". Also another date type field was set up as 'text" instead of "date."
Once I fixed it the query ran like it should have had in the first place.
Microsoft really needs to work on their error / warning messages to give more insight to the end the user...especially us noobs. LOL!
---In MS_Access_Professionals@yahoogroups.com, <ms_access_professionals@yahoogroups.com> wrote:
I imported both spreadsheets and may have linked one of them. How do I look up the SQL data?
Thanks.
Stan Pearse
---In MS_Access_Professionals@yahoogroups.com, <ms_access_professionals@yahoogroups.com> wrote:
Dear spearse- (name?)
1) Did you import or link the Excel data?
2) What is the SQL from your query?
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of spearse@...
Sent: Monday, October 28, 2013 5:45 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] RE: MS Access Message / I am confused
So I saved and closed the Access database. Then navigated to the link I saved. When I reran the query it then gave me a "Type Mismatch in Expression" message.
---In MS_Access_Professionals@yahoogroups.com, <ms_access_professionals@yahoogroups.com> wrote:
Built a simple MS Access query from two imported Excel files, which are closed and not open by anyone else, and I am getting the following message:
"The wizard is unable to open your query in Datasheet view, possibly because another user has the source table open in exclusive mode. Your query will be opened in Design view."
I don't understand. There are no other users.
Thanks.
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (5) |
Tidak ada komentar:
Posting Komentar