Search results

Try this one -- at least, it's a place to start -- and good luck. http://www.datamodel.org/NormalizationRules.html

Found the solution In my quest to make a phone book out of these records, I found a solution that works quite nicely, and I wanted to share it in the event others were trying to do something similar. I recreated the query as: select c.contactid, c.lastname...

Well, Rich, I beat myself up for several hours trying to concatenate them on the form. As I indicated, the three fields I wanted to contatenate on the form -- Bureau, Section and Unit -- were all included in the query. If I put the three fields on the form individually, they worked, but if I...

You're absolutely right, IgorB. I modified the query to produce the contatentation there, and dropped the resultant bound field on the form, and it worked at treat. Thank you for your suggestion and persistence, although that leaves me wondering why I can't concat the fields on the form...

This is not in the query -- the three fields exist as fields in the query -- I want them to concatenate on the form. But thanks anyway

In the criteria for the author field in your query, enter this [Enter Author Name] which will prompt users to enter the author's name. You can also use wild cards by entering (again, in the Criteria for the author name field): Like "*" & [Enter Author Name] & "*"

Yes -- all three fields that I am trying to concatenate are text fields. ???

But For Mulitple Rows? This query worked exactly right for a single instance (i.e. one contact record) -- but if I want to produce a phone book, I am summarily informed that "At most one record can be returned by this subquery." Keeping in mind the table structure I have, any ideas how I might...

Greetings: I am having problems with a form that is based on a query: I want to take three of the fields in the query and concatenate them into one field on the form. I think this is simple, but I can't get it to work, so clearly I'm missing something. The three fields in the query are...

Thanks you, thank you, a million times. Exactly what I was trying to do. I am very impressed - this works exactly right on the form -- for a single user. If I want to use similar logic for a phone book report, however, I run into problems. Is there a solution that will allow me to run a...

Greetings all: I have a challenge for extracting phone numbers. I have a database with mulitple tables, one of which is tblcontact and another a tblphone. In my tblcontact I have fields like: contactid, lastname, firstname etc. In tblphone I have phoneid, contactid, phonetype and...

Thanks again, FoFa, Exactly right, and I guess our posts crossed, as I hadn't seen your example with Right and the len function. I did need to adjust that , as follows: Right([Fullname],Len([FullName])-InStr([Fullname],",")-1) but it works a treat. Thanks tonnes for the explanation, as it...

I'm not quite sure how this works, but... Per my earlier post, I was successful extracting the surname from my fullname string, but had trouble with the first name, until I tried this: Mid([fullname],InStr([Fullname],",")+2) I'm not really sure why this worked, and why the Right function...

Whoops! That worked great for the lastname, but now if I try it for the first name, I get mixed results. I have tried using the code: Right([Fullname], instr([Fullname],",")-2) on the theory that I also don't want the space in the field: example, "surname, firstname" -- but this does not...

Thanks, FoFa - that worked a treat! I appreciate it.

Hi all, I know this should be a relatively easy solution, but I can't remember/think how, and I can't find a solution by searching.... I have a "legacy" database in Access2000 where a username is entered in a Name field as "Surname, Firstname". I want to split the data by extracting the...

use the input textbox to drive your query by placing the reference in your criteria field on the qbe grid. For example, you would place [Forms]![formname]![textbox] in the criteria field. This will run your query based on whatever is entered in the [textbox] field on your form. Then, base...

This One's A Killer This problem can be created even if you copy code from one form or module to another within the database. For example, I wrote some code on a command button that I wanted to use on another button in another form. I thought that made sense. Now I am recreating several...

Thanks! dcx693, you have the answer! That worked a treat. I was sniffing around the Len function, but hadn't used it properly -- and hadn't considered the IIF. Very clever: the actual update query I used was: UPDATE tblPhoneData SET tblPhoneData.PhoneNumber = "321-123-" & [PhoneNumber]...

Greeting folks: I have a query question: In a field (text data) that is used for phone numbers. Most of the phone numbers are 10 digits, but I have several hundred that are 4 digits (representing extensions in a local exchange). We are in the process of making our database accessible beyond...