WineSnob's latest activity
-
WineSnob replied to the thread Subtract integer from time duration.Thanks to all for help. Since I have to export the query in excel for the user anyway I will format and calculate the net time there. I... -
WineSnob replied to the thread Subtract integer from time duration.Yes DB Guy that makes sense. what would be the best way to convert start and stop time to numbers?
-
WineSnob replied to the thread Subtract integer from time duration.Total Time is a time data type
-
WineSnob replied to the thread Subtract integer from time duration.I will look into this but I am not great with VB code.
-
WineSnob replied to the thread Subtract integer from time duration.Total Time is formatted as "short time"
-
-
i am trying to subtract Personal time (number) from the Total Time (time duration formatted hh:mm) to get Net Time. I cannot seem to...
-
-
WineSnob replied to the thread Extra columns on export query.That did it. THANKS. Microsoft support took 3 days and still couldn’t figure that out.
-
WineSnob replied to the thread Extra columns on export query.I have almost always used the design mode to build queries. I tried using the wizard and it worked fine, it is only when I build it in...
-
WineSnob replied to the thread Extra columns on export query.Mike60, I understand. I have 5 tables but I created a sample db with minimal data to show what was happening. This is NOT the actual DB...
-
WineSnob replied to the thread Extra columns on export query.I figured out what the issue is. Access is adding ,* to the SQL statements. It does it every time I create a new query, I dont...
-
WineSnob replied to the thread Extra columns on export query.Here it is. The query does NOT have the last 6 columns in it, but when I export to excel there are 6 extra columns on the excel file. I...
-
WineSnob replied to the thread Extra columns on export query.I’ll try. The one I am using has linked tables. I’ll try to create a “fake” db. Thanks.
-
I have a query with a bunch of columns. In data sheet view it looks good. When I export the query to excel I get 6 extra columns that...
