If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Graph against Operator Characters (ACCESS 2K)
Hi friends
I create a Report (in ACCESS 2K) with Graph embeded on that, The Report and Graph are based on some fields of a query that have values with OPERATOR CHARACTERS set such as: "= 1.007 mg/dL" , "= 1.005 Ed/Le" so I CAN NOT create the Graph with these characters. I create a VBA function to eliminate the operator characters, but when I put this function to SQL query in VBA, it did not work and came up an error message "... the function is not included in aggregate function....". I think SQL query can not read VBA function. Is there any way to eliminate these character in order to create GRAPH without changing the Data from original table ? Please help me out... Thanks a lot in advance. Dan |
#2
|
|||
|
|||
Graph against Operator Characters (ACCESS 2K)
SQL can normally read VBA functions if they are in a standard module.
What is the SQL of your graph's Row Source property? -- Duane Hookom MS Access MVP -- " wrote in message ... Hi friends I create a Report (in ACCESS 2K) with Graph embeded on that, The Report and Graph are based on some fields of a query that have values with OPERATOR CHARACTERS set such as: "= 1.007 mg/dL" , "= 1.005 Ed/Le" so I CAN NOT create the Graph with these characters. I create a VBA function to eliminate the operator characters, but when I put this function to SQL query in VBA, it did not work and came up an error message "... the function is not included in aggregate function....". I think SQL query can not read VBA function. Is there any way to eliminate these character in order to create GRAPH without changing the Data from original table ? Please help me out... Thanks a lot in advance. Dan |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Access user profile | Michael Breitsameter | General Discussion | 7 | July 23rd, 2004 07:47 AM |
Useless Access 2003 | tired, angry, sucidial and bored | General Discussion | 10 | July 21st, 2004 11:52 PM |
Informal testing of Access 97 Skills | david epsom dot com dot au | General Discussion | 7 | July 13th, 2004 01:36 PM |
Error while running Access MDE | Hemil | General Discussion | 2 | June 21st, 2004 01:03 PM |
Access 2003 | RK | General Discussion | 12 | June 14th, 2004 10:16 AM |