Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: DanSeal
- Order by date
-
SQL: Trying to get thats Data Not in Subquery?!
Hi, I have a query in MSAccess. What i'm trying to do is return a result set that contains the data from the Master query that is NOT present in the sub-query. In Pseudo-SQL its something like: SELECT * FROM tblClients WHERE (entryDate between (getUnBookedStart() and getUnBookedEnd())) and... -
Can you call a macro from within a Query?
Hi, thats fixed it - thanks!- DanSeal
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
Can you call a macro from within a Query?
Hi, I have a query that needs to return data from the beginning of the current week, to the end of the current week. I have written some VBA code to work out the relevant dates and attached it to some macros to do this. What I want to do is call the macros from within a query to fill in the...- DanSeal
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
-
Returning n rows from a table
The article on techtarget did the job. Thanks guys. -
Returning n rows from a table
Hi, i'm trying to work out how to return n number of rows from a table, where n is some number. I am not bothered what the data is, i just want to be able to return say, the top 100 rows in the table. Thanks, Danny
