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 IamaSherpa 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: mrmangosir
- Order by date
-
Select last record and send result via E-mail
I tried creating a query and putting in a datediff statement to check the difference. But I do not know how to check for the last record within the query and run a macro from the result of a field. I tried running a SQL statement in VB editor, but I do not know enough to complete what I...- mrmangosir
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Select last record and send result via E-mail
I am attempting to run a Access DB that looks at a specific table call send. What I want is to run a query, with the datediff function and check the difference between a datetime field in the table send and the function now(). I want to see the difference between the last record's date and the...- mrmangosir
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
-
Refer to a parameter
Probably very easy, but I could not find it in the online help or a thread covering this. But, how do I refer to a parameter in my selection that is not ad-hoc. Example table1 client_id client_name table2 order_no order_date I want to create a report that when a user selects a client...- mrmangosir
- Thread
- Replies: 0
- Forum: Actuate Reporting Solutions
