Search results for query: *

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.

T-Sql My code is pulling all records where field2 = 0. In tableA are sales orders. Each sales order may have multiple records. Those multiple records will contain either a 0 or 1 in field2. What I need is to only pull from the many records for a sales order (field1) only ONE record where field2...

Thnx for all your help. It was the 'where' clause. I was selecting only certain records from the file that contained field "sopnumbe" and of course that particular record did not exist because of the <null> so therefore did not pull in the VIEW. Thanks again.

Sorry about the name of the title but hard to describe my problem. I am trying to capture NULLs on both ends. Meaning if sopnumbe is null then use order_num and if order_num is null then use sopnumbe AS master_SOP_Num. This works ok if order_num is null it populates master_SOP_Num, but if...

MS-Sql 2000 I was working on a project about 1 month ago that involed a crystal report using several VIEWs. My problem is that I was working with 3 different databases on 3 different servers. One, our live system and two other test systems. Stupid me can't remember on what database I made my...

MS-Sql 2000 I was working on a project about 1 month ago that involed a crystal report using several VIEWs. My problem is that I was working with 3 different databases. One, our live system and two other test systems. Stupid me can't remember on what database I made my last edit of the VIEWs...