Recent content by WineSnob

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 do appreciate the help though.

Yes DB Guy that makes sense. what would be the best way to convert start and stop time to numbers?

Total Time is a time data type

I will look into this but I am not great with VB code.

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 figure out the correct syntax. Not really sure why I am getting 15:00 either. Looking for line 1 to be 9:00 - 3 = 6.00. It is possible there could be a fraction...

That did it. THANKS. Microsoft support took 3 days and still couldn’t figure that out.

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 design mode that it adds the extra ,* I think I am good now. thanks

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. I was able to edit the SQL statement to make it work properly.

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 know WHY it is happening but now I can fix it and move on but i will need to check all queries going forward. SELECT Master.Timestamp AS [Date/Time Entered]...

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 hope I did the attachment right. Thanks. Also the drop and drag to move the columns in design view do not "stick" on the results page. Why is that? I have been...

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 are not part of the query but are part of the table. Why am I getting the extra columns on the export?

I have a form I would like to close without saving the record using a button. here is the code I have but it closes the form and it also writes the record to the table. Private Sub ClosewoSave_Click() Cancel = True Me.Undo DoCmd.close DoCmd.OpenForm "frmMenu" End Sub I found in a thread that...

That did it. Thanks to Minty and JHB.