Search results for query: *

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

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

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

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

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

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

I have a a form that has some general agency info on it. I have a button on that form that opens a subform that contains crosstab data based on a query. If I open the subform seperately it opens in datasheet view the way it is supposed to. However when I open the form from the button on the main...

Hi All, I have a a form that has some general agency info on it. I have a button on that form that opens a subform that contains crosstab data based on a query. If I open the subform seperately it opens in datasheet view the way it is supposed to. However when I open the form from the button on...

Hi All, I am a novice as far as integrating applications goes. Here is what I need to do: I have an ACCESS data base of info for different agencies. I also have a crosstab crystal report based on another database that contains monthly service data for each agency. I have a form in ACCESS that...

I am a total novice, I have a report and it has a grouping. I have two fields summarized in the group footer Distinct count of clientID and distinct count of EncounterID. I want to add another field that gives encounters per client for each group. I put the following formula field in the group...

Hi all, I have two different reports that should be coming up with the same total number of clients, however the totals are off by 10. I have checked table relationships, select criteria, and formulas over and over to no avail. Is there a way that I can compare the records that each report is...

Hi All, I have a report that has one group called section and then a list of agencies with details for each group. What I am trying to get is a count for agencies that have a value of X in a specific field by group. So I put a text box in the group footer with the following formula...

Hi all, I am a total CR novice. I need the syntax for a formula that will give a distinct count of field1 if field2 is equal to a certain value. Any help would be greatly appreciated. Thanks, D

Hi All, I have a crosstab report, and the row headings show up in alphabetical order. This is not the order I want them in. Is there any way to change the order other than putting a number in front of each column head? Any help is greatly appreciated. Thanks, D

Hi All, I have another crosstab issue, here is the layout of my crosstab: Male Female Contract A B A B A is a summarized field in the crosstab (distict count of clients) B is a summarized field (Count of encounters). I want to add a third summarized field yields...

Hi, I am having a major difficulty getting my crosstab formatted the way it should be. The crosstab yields two numbers Clients (distinct count) and encounter ( count). This is the format that report is produced. Male Female Contract 5 8 10...

Hi All, I have a crosstab and it is in the following format: The two values are Clients Served and Number of encounters. Male Female Contract 2 3 5 6 I want it to format like this instead: Male Female...

Hi All, I am using ACCESS to link to SQL server tables to query and create a report. I initially tried to import the tables and I got an "Invalid arguement" error. I then tried to link to the tables and was able to do so. I created a query and I can run the query and get the result...

Hi All, I have a couple of ACCESS databases that I use. I have one that I do not want the toolbars open on (and it works fine when I have just the one database open), however when I have both databases open at the same time, both databases show the same toolbars open. I hope this makes sense...

Hi all, I would like to open a report by clicking a button on a form in one access data base which opens a report from another access database. Is this possible? What code would I use to accomplish this? All help is greatly appreciated. Thanks, D