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 Mike Lewis 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: sweetelka18
- Order by date
-
Create A Number for Daily Use
Thank you for clarifying. I copied the code 'Retrieve JulianDate JulianDate = Format(CurrentDate - DateSerial(Year(CurrentDate) - 1, 12, 31), "000") from the Microsoft Knowledge articles. What you are telling me makes more sense. I've only programmed in College using Java, C++, and in...- sweetelka18
- Post #8
- Forum: Microsoft: Access Queries and JET SQL
-
Create A Number for Daily Use
Ok I have the Julian Day and the Constta 48 however I am not able to increment 001 daily. There is a table called visits that is a subform of a table called individuals. Each individual has a different visit. In the subform only the last visit is shown. Each visit the information is added for...- sweetelka18
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
Create A Number for Daily Use
I am trying to create a and 8 digit number that always begins with a 46 contains a Juliandate and then the order seen that day. I would like for it to print out in the reports and in one of the fields in a subform. Usually it is written when a person visits so it would need to restart numbering...- sweetelka18
- Thread
- Replies: 8
- Forum: Microsoft: Access Queries and JET SQL
