Recent content by Sumnor

I did earlier today - hmmm. Will look into it.

dhhookom and strongm - thanks much!

Well, I believe we are close, but the results do not yield strictly alphabetic characters: IIf(IsNumeric(Mid([DEVICE_NAME],3)),Left([DEVICE_NAME],2),Left([DEVICE_NAME],3)) Gives me: EE1 PRS MTR DS2

Hello. I am building a query in Access. One of the fields included in the query (Device_Name) has values such as: EE10000-1 PRS10004-2 MTR10018 DS20000-462 My goal is to split the string to the left of the first number so that I can have a column in the query that only houses the alphabetic...

Thank you so much for this response. I'm going to try and implement on my database. It may be long, but if it works for it is worth the effort! Warm Regards, Jennifer

Thanks for your reply. Since the save would default to a network drive, and mapping drives properly and/or searching for files is a bit too difficult for some of our endusers they really don't want a save until they have reviewed the data in Excel. I can easily display the query results in the...

I have an Access database running on a Citrix server that allows users to successfully export query results to Microsoft Excel. I use the following line in a module: DoCmd.OutputTo acQuery, "CourseOpty", "MicrosoftExcel(*.xls)", "", True, "" The problem is my users do not want to save the file...

I figured it out - a syntax issue - and can't believe that this was so 'difficult' for me to figure out. Geesh! Like "*" & [Forms]![Team]![Team] & "*

Thanks, Leslie - that certainly does works when entering/searching for a constant value. My question is a bit more complicated than that. I need to find a way to pass a value from a form to complete the search.

Hello. I have a query that references a form field as query criteria: [Forms]![Team]![Team] The Team field on the form allows the user to select one (1) name. An example of some of the form field values: Sandy John Jennifer The query successfully brings back all records that meet that...

Thanks, Mordja. I was able to apply the date format as you suggested and VOILA the pass-through query worked! Such a simple fix... I wish I had come up with it myself. It certainly pays to ask for help! [2thumbsup]

I have created an Access SQL Anywhere pass-through query that correctly brings back thousands of records. I would like to limit the number of records returned to only those created since 01/01/2003. For some reason I am getting an ODBC Driver Syntax Error regardless of the syntax I use. What is...

I am using a form to define criteria for a report. It works beautifully when selecting one (1) value, but I want to select more than one value. I thought that I could create a list box (named 'Status_Choices') that houses all of the choices for my end-user (Low, Medium, High, Closed). The user...

Unfortunately, I'm not looking to remove the comma separator altogether, just when the value doesn't require one. Thanks for your help. Sumnor

This worked great, but how will I remove the thousands separator? For some reason it appears. Here is what I have in place for this text field: Input Mask: \£#,##0;\£#,##0;\£0;\£0 Results I see in the report: £3,755 £5,431 £ ,105 £ ,628 I would love to get that comma out of there! Thanks for...