Recent content by Watermelon

Thanks so MUCH!!!!

Hi Everyone, I'm sorry. I didn't know which forum to best put this question in but basically I want to know how to get the ip address for a computer in the command prompt. I know there's some command line I can type in the Command Prompt to get this I but I can't remember. Can anyone help...

Hi, I want to create a calculated field as a sort expression on my report. I want this calculated field to sort by my LastName and FirstName fields. Can anyone help me with this? Do I need to create a calculated field first and then select this expression in the sorting and grouping window...

Hi Guys, Thanks for getting back to me on this. I just noticed after posting this that it pops up on the Timbokto Icon on the task bar on the bottom right of my screen. WM

Hi, I need to find out what the IP address is on my computer here. It's a networked, Windows 2000 pc. Can someone tell me how to do this? Thanks, WM

Hey Steve, That worked great. Thanks very much. WM

Hi, Thanks for the response. Do you mean divide by 100 again? I did try changing the format to standard and I'm getting some strange numbers. For example one student's GPA was 3.57% (this was correct). When I change to standard it comes out .04. I also tried changing standard and dividing...

Hi, Thanks for the response. The Grade Value field is defined as a number in the table. The format for the field on the report is a percent. I'm not that familiar with other formats but I tried standard and fixed and they didn't come out correctly Thanks, WM

Hi, I have a function that is calculating GPAs for students in our database. The problem is that it's leaving this percent symbol (%) on the end of the calculation. I tried to use the left function to remove this but I didn't have any luck. Does anyone have any ideas for how I can remove this...

Duane, That was great help. Worked like a charm. Thanks so much! And, Gary good tip as well. Thanks, WM

Thanks, guys. I like your suggestion Duane. I'll give this a try tomorrow and let you know. Thanks, WM

Hi, Can anyone help me? I'm trying to create an expression to sort my report on (under View/Sorting and Grouping). Basically, I want my report to sort by Last and First Name. These are separate fields in my table so I'm assuming the best way to use them as a sort on the report is by creating...

Hi, I'm trying to remove the read-only status of an Access database I'm supposed to be making changes on. I received this database from an end-user via email as a .zip file. When I extracted the file I was promted to enter a password which she provided me. I did this but then when I actually...

Hi, I'm trying to remove the read-only status of an Access database I'm supposed to be making changes on. I received this database from an end-user via email as a .zip file. When I extracted the file I was promted to enter a password which she provided me. I did this but then when I actually...

Hi cmmrfds, Thanks, bingo. That did it. Watermelon