Recent content by ausmoran

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...