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 Chriss Miller 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: andybeanland
- Content: Threads
- Order by date
-
SQL Between Dates Problem
Hello, I'm having a problem with a simple query. In the Query Builder in Access I have created a query to count the number of records between certain dates. SELECT Count([tbl_PacksSent].[DayCare]) AS NoOfDayCarePacks FROM tbl_PacksSent WHERE ((([tbl_PacksSent].[DayCare])=-1) And...- andybeanland
- Thread
- Replies: 7
- Forum: Microsoft: Access Queries and JET SQL
-
Recordset problem
Hello, I've got an really annoying problem - I copied and pasted some code for opening a recordset but it won't work now - I can't find the problem. This is what I've got: <code> Dim conDatabase As ADODB.Connection Dim rs As ADODB.Recordset Set conDatabase = CurrentProject.Connection Set...- andybeanland
- Thread
- Replies: 7
- Forum: Microsoft: Access Modules (VBA Coding)
-
combining SQL COUNT
Hello, I'm trying to do a simple count of who is attending on a register. What I would like to do is count the number of children attending (its for a nursery) for each day of the week and then create a report to show this. So far I've only managed to do several seperate counts which are like...- andybeanland
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
-
Date Time Field set to Null
Hello, I've got a problem with a date field that I just can't resolve - hopefully you'll be able to help. I have a series of text boxes (10 in total) which are for inserting start and end times for children attending a nursery for the different days of the week. The children don't attend every...- andybeanland
- Thread
- Replies: 4
- Forum: Microsoft: Access Modules (VBA Coding)
