Search results

I've been reading about Deleting Records with a Delete Query. I understand that I should create a relationship between tblUser2 and tblQuestionsResults with SurveyNumber and select Enforce Reverential Integrity and Cascade Delete Related Records in the Edit Relationships Box. Because the...

I figured this out!!! I took my left handed brain and turned it around to take another approach!!! I created a new query called QryCmbCountySearch. I used my tblProjectMaster, used County and Group by and made this the Row Source for my combo box. This table contains the counties as they...

neighbors children's heads

also falling off.

while turning green

and then explode

Yes, that is my quandary. The planners assign the projects and if the project crosses a county they may list one, two or all of them. If I seach for one of those counties I would like these projects to show up as well.

I tried again. It still doesn't work. It only brings up the files with the single county name and not multiple county names.

still doesn't work. thanks for trying though!!

up your nose

sorry that didn't work - it broke it :o

Using wildcard in a combo box search function?? I have a form with a combo box to search (by county) on it. The problem is that the data may be listed by multiple counties and the search is by single counties. There are 99 counties listed. The data comes from a different source and the...

I have the following if statement IIf(Left([tblQuestions].[PageCode],7)="General","_",Left([tblQuestions].[PageCode],InStr(1,[tblQuestions].[PageCode]," ")-1)) & Format(Mid([tblQuestions].[PageCode],InStr(1,[tblQuestions].[PageCode]," ")+1),"0000") This works in one query (qryQCsubform) but...

My thoughts exactly. The build query works but only on one side. First I thought I'd try the if statement but now I think another query would be better. I'll try to let you know how it goes.

Gee that makes a lot of sense! duh, guess I could have stared at that for hours! Unfortunately I don't think it's going to work. I think I need to write 2 different queries to build the surveys. One for each survey_type. Thanks! Rhonda

If[tbluser]![survey_type] = "QA" then [tblQuestions]![UserType] = "b" else ("b" or "d") Do you see something wrong with this? I received an error message that said I had invalid syntax - maybe an operand without an operator...it was highlighting the word 'then'. What I'm trying to accomplish...

I see that both expressions do technically the same thing - end result, correct sort. But this last one is cleaner and easier for me to understand. Thank you very much! Rhonda

I've finally (nearly) cleaned off my desk after missing a week of work and now ready to dive back in. I've been reading Doug's last post and have a question. I understand the leading zero's. I kind of understand those functions, 'still learning'. I understand that 1.1a = 0001.1 & 1a but I...

Hi Doug! I am very interested in learning this. I am just on my way out of town (oh boy, SE Iowa!!) and will return in a few days. I will then have time to look at this more closely. Just wanted to let you know, so you wouldn't think I didn't have any interest. I do want to learn to do...

After more experimenting I think I should be using the code the "theprez" supplied. It's easier for me to understand and I'm still not sure about the output of Doug's. (sorry Doug) Here's another example of that: Sheets Expr1 1.2c 0001.22c 1.2d 0001.22d 1.2e 0001.22e 1.2f 0001.22f 1.2g...