Recent content by bhowerton
-
B
I have some questions about writing/using SQL; Can I ask those here in this forum?
Hello everyone, I have a few questions about using/writing SQL. I would like to start programming in SQL. I am a Database Manager and I have a lot of reports that are in Text Files (these Text Files contain a lot of Necessary and UnNecessary data. I want to try and use SQL to format them and... -
B
Trying to find fields located among other very similiar fields in the same column
Trying to find records located among other very similiar records in the same column I have a column full of records that are very similiar...example: 8EN41P901217<<<---------- 8EN41SH62227 8EN41SH63227 8EN41P971228<<<---------- 8EN41SU42225 8EN41P943225<<<---------- 8EH161Q12216 8EN41SG81225... -
B
Need help in making a query to sort out information
Reply to your Last Post... Hello again, First, thank you for all of your help!!! Second, I have attached a couple of jpeg pictures of my database to this post. Is this what you were asking about….I mean what you wanted to see? My table is named “RAWDATA”. The first is a picture of the... -
B
Need help in making a query to sort out information
Aleb, I need additional help...Please help me!! Aleb, I did as you said. Here is my code with my fields included, but I am getting an error (see the bottom of this post). SELECT distinct RAWDATA.MISSION_ID FROM RAWDATA WHERE (((Mid([MISSION_ID],1,2)) Not In... -
B
Need help in making a query to sort out information
Aleb, I need your Help again......Need help in making a query to sort out information Hello Everyone, If you do not understand this thread please read it in the attached Word Document - hopefully it will make more sense there. I have a database with a table consisting of many different...