Search results

Is there a way to check if the last character in a string is a certain data type? For example, for the following strings, I need to do one thing if the last character is text, another if it is a number: 7E85C 7E1009 7E14 7E1411A 7E827 Thanks.

Thanks Pat.

Thanks for the reply Doc_Man. I was hoping I was wrong, but had assumed that this would be a pain in the rear. I can get rid of the 7E- prefix, but how do you scan the characters one at a time to see if they're alpha or numeric?

Is there anyway to determine the maximum Permit Number given the following Permit Numbers? 7E-994 7E-3546A 7E-110 7E-25 7E-887A 7E-36B The number I need to display for the user is 7E-3546A, but since this is a text data type, the Max function returns 7E-994. The Last function doesn't work...

Hey Jon, Thanks for the reply. That looks like it might work for me. Not sure I understand what the Criteria setting <>False does.

My parameter query using Between [StartDate] and [EndDate] works well. How would one set it up so that if the user enters nothing in the StartDate and EndDate fields, all records are returned? Thanks.

A field in one of our users' tables has odd entries such as: 1152+10 22+94 15+532 28+83 3+722 1084+75 and so on. The number of characters on either side of the + sign can always vary. The problem is that in reports, the user wants all of the + signs perfectly aligned. Obiously, justifying the...

Not sure how to run this query. I have two columns, Year and ReferenceNumber. I want to retrieve the maximum value in ReferenceNumber for the maximum Year. In other words, if the values in my rows are: Year ReferenceNumber 1999 110A 1999...

I have a form which I admit is a bit busy, but I've seen and worked with much, much worse. When I try to filter by form, I receive the error: Too many controls on form to allow Filter by Form. After I click OK and the message goes away, I am allowed to filter by form and it works fine. Has...

Figured it out, thanks!

Is it possible to set up a query so that when a report is run, the user is prompted for a date and then all records between the entered date and four years prior to that date are returned?

I have a report that will prompt the user to enter a Purge Date. The query behind the report should then retrieve all records from the Purge Date backward four years. I have been working with a function like DateAdd("yyyy", -4, [PurgeDate) but have been unsuccessful so far. I am not sure how...

I have a Contracts table (primary key: ContractID) and an Employee table (primary key: EmployeeID). I guess this is a many-to-many relationship as an employee can work on many contracts and a contract can have multiple employees. I have created a junction table called Details where the primary...

Thanks, I'll give it a try.

I have a very simple form that users will use to locate a permit. The form has two fields, cboYear and cboReferenceNumber, and one command button, cmdFindPermit. The form works fine. However, the user will be required make selections from both fields and I would like to add code that produces...

Thanks DT, I will go to the site and take a look.

I am using Access 97. I would love to see the Add-in. Thanks.

Pat, thanks for your reply. My query still will not retrieve a record that has a null. I have a very small test table with 10 records. There are 7 columns: ContractNumber CountyID RouteID Section Location ImprovementTypeID ResidentEngineerID One record has a null in the ResidentEngineerID...

SELECT tblProject.ContractNumber, tblProject.Section, tblProject.Location, tblResidentEngineer.ResidentEngineer, tblRoute.Route, tblCounty.County, tblImprovementType.ImprovementType FROM tblRoute RIGHT JOIN (tblResidentEngineer RIGHT JOIN (tblImprovementType RIGHT JOIN (tblCounty RIGHT JOIN...

Does anyone out there know of a sample Search form that I could study?. What I have in mind is a form with multiple combo boxes. Records are retrieved based on what the user selects in the combos. If all combos are left blank, all records should be retrieved, even if some of them contain...