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 dencom 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: JustJosh478
- Content: Threads
- Order by date
-
Concatenate fields on form and write back to table
Hello, I seem to be beating my head against the wall on something I should know and something I know I've done before. I have a form that takes text box A and concatenates text box B to create text box C. I have the correct concatenation string showing up on the form so i know it's putting...- JustJosh478
- Thread
- Replies: 2
- Forum: Microsoft: Access Forms
-
Alter Table to Change or Clear column format
I have created this statement to change a column from date/time to number and it works... ALTER TABLE [Supplier Workbook] ALTER COLUMN [Total Time Spent] Number but it's keeping the format of "h:nn:ss". Is there a way to add a statement to my query to clear or change the formatting to...- JustJosh478
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
Differences in Time Calculations from Excel to Access
Hello all, I'm struggling trying to find out why Access is calculating time durations on certain data differently than Access. Here's my story... There is data in a spreadsheet that looks at time duration based on the NETWORKDAYS code and gives a duration of how long a ticket has been open...- JustJosh478
- Thread
- Replies: 18
- Forum: Microsoft: Access Queries and JET SQL
