Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old July 31st, 2006, 10:47 AM
Registered User
Points: 1,897, Level: 17
Points: 1,897, Level: 17 Points: 1,897, Level: 17 Points: 1,897, Level: 17
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Apr 2005
Location: Mumbai, Maharastra, India.
Posts: 352
Thanks: 14
Thanked 0 Times in 0 Posts
Send a message via Yahoo to rupen
Default Will this query run perfectly??? ...


select sum(time_hr),sum(time_mi) from timesheet where wtid=1 and workdate between #24-July-2006# and #28-July-2006# and projid in (select Proid from ProjectMaster where ClientID in ( select ClientID from ClientMaster where team = "& objRs(3) &"))

Rupen Anjaria.:)
------------------
We CAN'T avoid problems, but can solve it.
  #2 (permalink)  
Old August 1st, 2006, 01:17 AM
Authorized User
 
Join Date: May 2006
Location: , , India.
Posts: 47
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to Ashfaque
Default

Select Criteria fields in query first then set the conditions. Then errors can be traced out.

Ashfaque
  #3 (permalink)  
Old August 1st, 2006, 06:11 AM
Registered User
Points: 1,897, Level: 17
Points: 1,897, Level: 17 Points: 1,897, Level: 17 Points: 1,897, Level: 17
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Apr 2005
Location: Mumbai, Maharastra, India.
Posts: 352
Thanks: 14
Thanked 0 Times in 0 Posts
Send a message via Yahoo to rupen
Default

I didn't get your answer can u pls be more specific?

Rupen Anjaria.:)
------------------
We CAN'T avoid problems, but can solve it.


Similar Threads
Thread Thread Starter Forum Replies Last Post
please php is not working perfectly well p2ptolu Beginning PHP 1 March 27th, 2005 09:56 AM
Query to be run against both SQL and Oracle NK Oracle 2 April 26th, 2004 05:28 PM
Run query automatically mateenmohd SQL Server 2000 9 March 28th, 2004 03:35 PM
run total in query stoneman Access 1 December 23rd, 2003 04:43 AM
run query problem musharaf PHP Databases 2 September 22nd, 2003 02:11 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.