Recent content by texan1956

I've got a table with a date field (mm/dd/yyyy). I'm using a parameter query asking for the mm/dd to be entered. My problem is that when I enter the 04/20 as the parameter I only get back one record when I know that I have more than one record that meets that parameter. Is there a reason for...

I need to be able to determine the position number of a character within a text field. Is there a function that I can use to identify this? (ex: Mid()??) I have an update query created with the criteria set for finding records with two or more consecutive spaces embedded in the field. What...

As a new user of Access I need to do two things: 1) create a function, 2) run the function from my update query. I'm pretty sure I can create the function as a module, but how do I call the module from my query?

I need to know how to use an Update Query to eliminate leading spaces in a table. As a fairly new Access user, this is something I have not done. Thanks in advance for any help!