•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 425,932 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 1,655 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS Access and FileMaker Pro advertiser: Programming Forums
Views: 3478 | Replies: 0
 |
•
•
Join Date: Oct 2006
Location: Maryland
Posts: 3
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
The following SQL results in an "invalid procedure call" message.
SELECT ViewtimeHCPick1WRes1.X
FROM ViewtimeHCPick1WRes1
where (((ViewtimeHCPick1WRes1.X)>2));
SELECT ViewtimeHCPick1WRes1.X
FROM ViewtimeHCPick1WRes1;
works fine.
ViewtimeHCPick1WRes1 is a query.
X is a calculated field that results in a number of format x.y or x.
Any suggestions as to why the where clause is not working?
SELECT ViewtimeHCPick1WRes1.X
FROM ViewtimeHCPick1WRes1
where (((ViewtimeHCPick1WRes1.X)>2));
SELECT ViewtimeHCPick1WRes1.X
FROM ViewtimeHCPick1WRes1;
works fine.
ViewtimeHCPick1WRes1 is a query.
X is a calculated field that results in a number of format x.y or x.
Any suggestions as to why the where clause is not working?
|
•
•
•
•
•
•
•
•
DaniWeb MS Access and FileMaker Pro Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- Flex Grid error "Invalid procedure call or argument" (Visual Basic 4 / 5 / 6)
- How to connect a SQL stored procedure to a windows application? (VB.NET)
- Far Procedure Call in 8086 or 8088 (Assembly)
- This is the only thing i have not been able to get rid of... Tricky virus or trojan (Viruses, Spyware and other Nasties)
- IE Opens by itself (hijack log included) (Viruses, Spyware and other Nasties)
- QUICK! Access SQL using ASP and javascript (ASP)
- Stored procedure call with ADO (C)
- lost admin rights and constant look2me.com popup Help Plz (Viruses, Spyware and other Nasties)
Other Threads in the MS Access and FileMaker Pro Forum
- Previous Thread: Do Loop
- Next Thread: Obtaining top 10 performers by category
