Search results

I don't think I explained my problem clearly. I have one field (Ownertype) with four different choices:They are Sponsor,Owner/Contractor,Owner or Contractor. If at all possible, I want a query that can choose one owner when there are two owners per record. Right now if I create a query with...

I tried grouping the query it still repeats the records if there is owner and owner/contractor. Grouping does not help me pick which record I want when there are two owners for one record.

Please help! I have a many to many table with three fields: Owner, ProjectName, Ownertype. The ownertype field can have four choices: Sponsor, Owner/Contractor, Owner, or Contractor. The problem is if ProjectName has both an owner and owner/contractor or two owners in the ownertype field is the...

Thanks. I'll try your suggestion.

I created a crosstab query based on a field called CB that currently has 17 different community boards thereby creating 17 columns. I need to have the values in the columns concatenated and separated by a comma into one field that can be used in a report. Also, this crosstab query has...

Hello I am reiterating my message posted 12/17/01;I did not get response to it. Is there anyway to concatenate the results of a crosstab query without using the "&". I tried writing an expressing using the Join function in the expression builder, but I get an error message saying "undefined...

In the query grid enter Date()in criteria under the DOB field.

I did what you recommended and it worked. Thank you very much.

Are you telling me to use the Trim() function to remove spaces between strings of text? If you are, I am currently using the Trim() function, but the spaces are not removed.

You can write the 10th criteria in any one of the 9 lines as in the following example "BK02" Or "BX02". You can write several selections followed by Or on one line. I hope this helps.

I have posted two previous questions (12/17/01 and 12/24/01) and and I have not gotten a response for either question. Am I not explaining my problems clearly or are my questions not possible to do? Please let me know.

Hello How do I remove spaces between text that is concatenated. I tried using LTrim and RTrim but that did not work. Here is the expression I am currently using: Trim([Buildings_Crosstab]![1] & " " & [Buildings_Crosstab]![2] & " " & [Buildings_Crosstab]![3] & " " & [Buildings_Crosstab]![4] & " "...

Hello I am reiterating my message posted 12/17/01;I did not get response to it. Is there anyway to concatenate the results of a crosstab query without using the "&". I tried writing an expressing using the Join function in the expression builder, but I get an error message saying "undefined...