Recent content by dday01

Hi All, I have a crosstab report where the columns are age ranges based on a formula that I created. All works fine accept that the columns only show up if there are totals for the columns. Is there a way to make each of the age range columns be displayed even if there are no numbers for that...

Thanks both of you for all of your help. I just needed a down and dirty solution for one report that I needed to put together. D

Hi All, I am a complete novice with SQL. I am trying to create a view based on an existing view (I think you are allowed to do this?). here is what my sql looks like: SELECT * FROM dbo.enc_serv_view WHERE (ProgName = [HR (RW) HRRR ]) OR (ProgName = [HR (RW) HRRR ]) OR...

Thanks LB, that looks like a good starting point, I'll play around with it a little bit. I neglected to mention that it has to work for the last 3 months based on when the report is run. (it is not just an end of year report, I need to be able to run it any month and return rows with a value of...

Hi All, I have a crosstab report that displays months as columns and agencies as rows, the values are number of client encounters. What I am trying to do is have the report display rows only when the value of the last 3 months is zero. ie. the row for the last 12 months would only be displayed...

JRToad, That worked! Thanks alot for the help! That made my week alot easier. Thanks, D

Hi JRtoad, I tried putting the qualifiers back in. The following is the code I submitted, but received the same message: SELECT * INTO ai_clien_prev FROM ai_clien WHERE tc_id IN ( SELECT DISTINCT a1.tc_id FROM ai_clien a1 INNER JOIN urs.dbo.ai_enc_prev a2 ON...

Thanks for the response JRToad, I tried that select statement and got the following error: Server: Msg 107, Level 16, State 3, Line 4 The column prefix 'ai_enc_prev' does not match with a table name or alias name used in the query. Again, I have to footnote this by saying that I just started...

Thanks for the response donutman, Actually I only want distinct intances of the full records from the ai_clien table to go into the new table based on the TC_ID field from the ai_clien table. When I tried using DISTINCT* in the select statement, I received the following message: Server: Msg...

Hi Folks, I am a total novice. I am trying to write a query with two tables, a client table that has a one to many relationship to an encounter table. I want the query to return distinct client records. The client table has an extensive amount of fields in it and I would like to avoid having to...

That did the trick, thanks alot Roy! D

Hi All, I have a report based on a query. Each record in the query has the record number from table I am querying on. My query returns a percentage of the records from the table. In my report I want to include the record number, but I don't want the gaps. when the records display in the report...

Hymn, Thanks that worked (there was a missing reference). Thanks alot for the help! D

Thanks for the response, I have to admit I am an absolute vovice. When I went to the tools menu, References was greyed out. And I don't know where DAO3 is to tick. Thanks, D

Hi All, I am trying to convet an ACCESS 95 database to ACCESS 2000. The database is split into 2 MDB's. One with data and one with forms, reports, etc... When I converted there was a message that it could not compile. Now when I try to open most of the forms or reports I get a message that says...