Recent content by NNNY

Good day all, I have a table containing a list of facilities with their specific attributes (code, name, address etc.). Due to the fact that certain facilities belong to the same owners, I am trying to write a view that will create these groups based on the values I will enter, so that I can...

Good day all, I have a table containing a list of facilities with their specific attributes (code, name, address etc.). Due to the fact that certain facilities belong to the same owners, I am trying to write a view that will create these groups based on the values I will enter, so that I can...

Good day all, I just encountered an unusual issue with exporting to Excel and would love to be able to find a solution for it... In my original report, I had several fields that are numeric (or date) by nature. When exporting to Excel, they did come up as their original type with no issues...

Gotcha....Tried initially as a command and it slowed down the server in a big way..... Finally had a chance to create the view and it worked perfectly....THANK YOU :-)

Hello, and thank you for your reply [bigsmile] My apologies, I neglected to list the other tables that are involved in this query, as I am not sure how to link them, and whether the command should change based on that... Here is the location of the data: Jobs table - All job information with...

Hello all [dazed] I have a bit of an issue, and I’m wondering if anyone can be of assistance… I am trying to group data that is recorded in different fields, but is identical in some cases…..let me explain: In my Vehicle_Schedule table, I have a separate field for “Driver” and another for...