Recent content by markajem

Denise thanks, they both work nicely.

Sorry, syntax again. Trying to convert a DateTime to display as a Date in a VIEW I am creating. Data is: 2006-07-15 00:00:00.000 Would like it to be: 2006-07-15 Also would anyone know of a good link/s where I can go and find some of the syntax listing I need. I am green at this and...

That's the one Dave. Thanks, appreciated.

Can't find in my records; know I had it. What data file contains the paths to all the shortcuts for users for GP v6. Thanks

That did it. Thanks for your help.

Confused! I am using a calculation for the date. I can't use the date field because it will not be correct. I am going back 45 days from the date field; so therefore the month will be back one month. When doing so I do not have the option to Group by month, day etc. It only Groups (sorts)...

I am presently using a formula to calculate -45 days from a date and using this formula to create the Group and formatting the group to show mmm-yy. My problem is that it is sorting the group by acsending order instead of by month order. The numbers are coming out correctly. I do not have the...

When selecting a customer in Cards>Sales>Customers after the window opens and I select a customer the following error pops up on my screen. (Don't think it's a rights thing because I have full rights in GP across the board. I have tried logging into GP from different system in the office and I...

Never mind, the records cleared on their own. Thnx

GP v6 One of my users can not access a cash batch. According to Dynamics SY00800 his user name is listed twice in there. He is logged out of GP and I do not see him under User Activty. Also no mention of him on Citrix boxes. Is it safe for me to just delete these two records thinking that...

Also I should have mentioned and made more clearly. It was not a new VIEW but the same VIEW altered with the same name.

I thought of that but that I believe would be that if I removed a field from the original VIEW and still had it in the report then it would ask me where to map it. I solved it though. Was not thinking straight (as usual). I had to do "Verify Database" and it added the new field to my existing...

C v8.5 I had to change a VIEW that I am presently using in my report. Existing VIEW field01 field02 New VIEW field01 <-- same as existing field02 <-- same as existing field03 <-- added field I did this once before a while back and for the life of me can't remember. All my fields that I am...

Zathras thanks for the extra tips. Will study up on them. Meantime, this should be ok as is. The data tables are not that large at all. Few hundred records. I have combined the VIEW with a view more and use them in a crystal report. The report pops up almost instantly with data.

Used below code and worked great SELECT field1, FROM table1 GROUP BY field1, field2 HAVING field2 = 0 Thanks to everyone that helped me.