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 Wanet Telecoms Ltd 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: puttergirl
- Content: Threads
- Order by date
-
Eliminate commas from beginning and end of strings
I have a form set up where you select many items from a list and when you save it, it transfers the values into one field on another form separated by commas. Sometimes after changes, I end up with commas at the beginning or end of the string. I would like a function that would remove the...- puttergirl
- Thread
- Replies: 19
- Forum: Microsoft: Access Forms
-
Help with dynamic crosstab query report
I'm creating a report using the code in this article: http://support.microsoft.com/kb/328320 My crosstab query looks like this: TRANSFORM First([2 yr hx].[S/S]) AS [FirstOfS/S] SELECT [2 yr hx].EXIT_DATE AS [EXIT DATE], Count([2 yr hx].[S/S]) AS CITATIONS FROM [2 yr hx] GROUP BY [2 yr...- puttergirl
- Thread
- Replies: 1
- Forum: Microsoft: Access Reports
-
Help creating unique identifier reusing a range of numbers
HELP me; I'm really stuck. I need to create license numbers for Xray machines based on the county and type of machine. The number will have 3 parts- a county code followed by a dash, then a 4 digit number within a range depending on machine type, and then a distinguishing letter at the end to...- puttergirl
- Thread
- Replies: 6
- Forum: Microsoft: Access Modules (VBA Coding)
