Thank you so very much, however, I actually want to create a new field for each item, rather than concatenating them into a single field.
I very much appreciate your kind help.
Austin
I have multiple records in a table where the ID is the same, but the CommitteeName exists in mutliple records...for example:
ID CommitteeName
23 Ethics
23 12A Working Group
19 Board of Directors
23 ResortProperties
I would like to get the committee names...
I have tried all that I can think of and cannot figure it out! I have a number of reports in which I use text boxes for paragraphs of text. When I design the report in CR (version 9) everything looks fine. I ensure that the right edge of the text box does not come close to the edge of the...
I have a piece of VBA code in which I have a SQL insert statement with a problem. I think there is a relatively simple syntax error that I can't seem to find and am hoping that somebody might be able to take a look at it and point it out for me. Here's what I have:
sql = "insert into...
I have a SQL table in which I have home sales records with the following fields:
closingDate County SalesPrice
I have been attempting to figure out a way to calculate the MEDIAN for the sales price, broken down by county for a specific date range (year-to-date).
Is there a way to accomplish...
Can someone tell me what is wrong with the syntax here?
SPEC:IIF([field2],"100","",IIF([field3],", 102","",IIF([field4],", 106","")))
Thanks in advance
Austin
I have a database which includes member records in one table and in a joined table, it also includes specialty codes. Each member can have between one and seven different specialties. When I run a simple query, I end up with multiple rows for the same person, because of having more than one...
I need to develop a crosstab query that will include multiple values. The wizard allows me to set up a crosstab for every month in a particular year. But what I need to do is create columns for different months and or years. Is this possible?
Thanks in advance,
Austin
I am attempting to create a query that will produce four columns of data for four different time periods. Perhaps it is best if I give an example:
I have a flat data file with the following fields
ID Number
Price
Date
County
I would like to create a dataset broken down by...
Thanks, Chris for your reply. I think I failed to clearly explain the problem that I am facing. I actually do have two tables (one for the member data and the other lists specialties...they are connected via a member number). I want to be able to generate a dynaset where I have ONE member...
I have a table with member records which include a specialization code. Since some members have multiple specialties, they have multiple records. I am attempting to query the table and extract a single member record which will include all of their specialty codes (from multiple records). Is...
I've done it many times before, but I cannot recall how to parse the LASTNAME out of a field that contains LastName FirstName MiddleInit. I seem to recall that I used the LTRIM function....but I can't get it to work. I want to create a LASTNAME field so need to extract ONLY the lastname from...
I have a fairly simple database (Access2000 Developers Edition) with a table with only six fields. Each month I will receive comma Delimited ASCII text files from around 40 offices. Each file will contain between fifty and two-thousand records.
As it is now, I am manually importing each...