The % Sign

[mr moe]

I have a dabase that I"m working with. It has a "% Complete" as a column name, the problem is that I can't reference that name, it's giving me an error problem even if I included brackets in between. Ay Suggestions?

 

[dcx693]

I would think that [table_name].[% Complete] or just [% Complete] would work. Is that what you tried?

 

[mr moe]

Yes, that's what I tried, actualy the way I'm doing it is by importing data from ms project. similar to this. rstask.[% Complete], for all the other columns it works expect this one.

 

[dcx693]

Can you post more of your code? If you're using:
rstask.[% Complete]
to pull the data using a recordset object, perhaps you can try:
rstask("% Complete")
which is equivalent to:
rstask.Fields("% Complete")
which is equivalent to:
rstask![% Complete]

 

[a.sinatra]

Use a better naming converntion next time

.2 cents
________
Herbalaire Vaporizer

 

[mr moe]

Thanks dcx693, I was able to call the column from project but the problem now is that I can't retrieve anything, maybe because % complete is a calculated column in ms project.



a.sinatra : Maybe you should contact microsoft and have them use a better naming convention. % Complete is a column in MS Project, basically it calculates percent complete data from start and end dates for the tasks.



dcx693: Could you please look at this issue i'm having: Here is the link :http://www.access-programmers.co.uk...d=305975&sortby=lastpost&sortorder=descending

 

[mr moe]

Sorry I forgot to include part of the code: here it is:
rsTask!TaskID = tsk.ID
rsTask!TaskName = tsk.Name
rsTask!TaskStart = tsk.Start
rsTask!TaskEnd = tsk.Finish
rsTask!Notes = tsk.Notes

 

[dcx693]

I was able to call the column from project but the problem now is that I can't retrieve anything, maybe because % complete is a calculated column in ms project.

What do you mean that you can't retrieve anything?

 

[mr moe]

Dcx,
I'm so sorry for returing late, but I meant to say that the code is working fine but when I run it the % column is blank, meaning I'm not getting any data back from ms project, I think because % column is a calculated column which means like it comes from four different columns. Basically it's not static. thanks.

 

[a.sinatra]

I think you will probably be able to change the column name easier than you can fix this problem.

I concur!
________
Marijuana Vaporizers