Search results

Genius!! thank you soo much!

no no leading spaces... i am still not certain why it wont simply give the greater value.. confusing.. so then i went and created an "make table" by doing below Year: Right([02D_Record]![Birth Date],4) Month: Left([02D_Record]![Birth Date],2) Day: Mid([02D_Record]![Birth Date],3,2) Expr1...

thank you, its text

Hello, why isnt this query working? SELECT name, Date1, Date2 FROM table1 WHERE Date1 > DATE2; values in the table itself Name Date1 Date2 John Smith 08021977 07281978 Paul test 03142011 06061963 should return the below correct? Since date1 is greater then date2 (08021977 is...

No there is no expected range it could be any date, basically its a file with birthdate of many, and it needs to be in yyyymmdd format. its not a form where i can control the user, its a file that i import and do some basic error checking and other things and this would be one of the checks i...

ok yes so it can be in mmddyyyy or ddmmyyyy only but it needs to be in yyyymmdd. No there are no seperators

Hello, does anyone know how to edit for date format? For example, when i pull in a text file, one of the field is date and it would be in yyyymmdd, however sometimes if the user doest create the text file correctly then the date would be entered in as mmddyyyy or some other incorrect date...

Thank you for the post Sean, however my question is more if the length is correct but instead of having 9(09)V(06) format they sent in 9(09)V99 format, then it would show the output as #Error, but instead i'd want it to say "Invalid Format" or instead of the #Error it would say "Invalid...

one question gemma-the-husky, please how do i write an if else statement in the select statement itself? so for example: SELECT Income, '$' & cdbl(Left([Income],9) & '.' &right(income,6)) AS income_Dollar_amt FROM Income_Record; gives me the result below Income...

that worked like a charm! thank you!

ok so i got the last 2 digits to work Expr1: Left([Income],9)+'.'+Mid([Income],10,2) but see the first part before the decimal point can vary... so some numbers could be as follows...does anyone know how to loose the leading zeros's? 000009059790000 000009059.79 000009343350000 000009343.35...

Hello, does anyone know what built in function i can use to conver a COBOL number into a regular decimal number? For example COBOL Picture 9(09)v9(06) so the number would be 000009059790000 and the conversion would be 6 digits to the right of decimal and 9 digits to the left. so the...

thank you Bob! this was extremly helpfull...

thank you Bob. this is great! if i want the excel to be visible when its done running then i know i have to put ApXL.Visible = Ture but would that be at the end of the code? also one more question it puts the last query first when exported, is there a way to get the first query to discplay first...

thanks Bob!

just realized i cant attach anything in the private message... at i couldnt figure it out... from what i can tell the path nameis right and also i had deleted the spreadsheet so it doesnt seem like thats the issue here is the mini DB...you'll have to select all checkboxes and then export...

i am still not getting why it opens the spreadsheet first with all the queries in a different form... then i would close out the spreadsheet, it asks if i want to save it, i would say no and then it brings me back to the DB where the error message comes in a pop up and then if i go back to my c...

thank you Bob. this is working however it first pulls an excel file with some other result and then give me the error message once i click ok then it opens up the actual results that i want to see... so my question is how can i make the first spreadsheet that open to go away? and what does these...

you are much better then me for sure so don’t sell yourself short John! all in all thank you for your response and assistance! Hopefully i'll get this to work one way or another! thank you once again!

can this be used for queries? also do you know of a way to exprt query name to excel using automation for multiple queries in multiple tabs?