Search results for query: *

Question for the SQL GODS?? What's the proper(syntax)for a make table query in access where the data base asks the user to input name of the new table?? something like: SELECT [IS USED FOR MAKE TABLE QUERY].*, * INTO [???enter table name???] FROM [IS USED FOR MAKE TABLE QUERY]; Thanks Jason.G

Question for the Access GODS?? What's the proper(syntax)for a make table query where the data base asks the user to input name of the new table?? SELECT [IS USED FOR MAKE TABLE QUERY].*, * INTO [???enter table name???] FROM [IS USED FOR MAKE TABLE QUERY]; Thanks Jason.G

Does anybody know how to convert: TimeValue ({mo_agent_unit.tdTime}) to a number?? I seen a number of differnt ways to convert numbers to time but not back to a number. something like 5:00:00am and 5:30:00am to 05 and 05.5 Help, Help!!

Does anybody know how to convert: TimeValue ({mo_agent_unit.tdTime}) to a number?? I seen a number of differnt ways to convert numbers to time but not back to a number. something like 5:00:00am and 5:30:00am to 05 and 05.5 Help, Help!!

Hello ALL :) I'm new to SQL and I'm trying change the results of my query to a week day number instead of a smalldate: (IE SUNDAY would 1. and monday 2) I know its a datefirst function but I'm unable to get the correct syntax ?? DECLARE @begin smalldatetime, @end smalldatetime SET @begin =...

Trying to color code the group footer2 formula so if{General Information.Job Run Date}january is lower or high february the font will change color. If ({@GF2:Abandon%Connects},{General Information.Job Run Date}"January") > ({@GF2:Abandon%Connects},{General Information.Job Run...

Hello All I have report with 4 groups that I'm trying to color code with specific information and I've hit a road block as how to over come it. What I want to do is this. If a number in one group is higher or lower than another group then CRRED. Below is one formula: GF2:Abandon%Connects if...

Crystal 8.5 Running total fields. Is there a way to create a conditional running total from the group footer totals instead of the details section. When I try to select a group sum its telling me (invalid section) Thanks Joe

hello all. Im trying to do a specific count of a group within a 30day report and put the total in the frist group GF1: The group2 GF2: is job_date. what would be the proper syntax if any or is there something completely different. Count (DayOfWeek ({@D: Date Conversion},{General...

HELLO ALL. I have a 30 day report that in includes to two groups: 1 age and the other is day. What is the proper syntax to to get an average of group 2(day)for all days of certain a day of the week within my 30 day report: such as the average dials of all the sunday group totals. Something...

Hello All, I am trying to get sum totals for a secondary group and put them in the report footer of the report, Would I have to create a different group and hide it or is there some formula that I haven't figured out yet. Example: INFO GH1:..............AGE1 GH2:...........TFST GF2...

Using the fomula editor,how i fomat a certain feild in the details section of my report. PH: jobname jobdate jobnumber DET: AG2PM 2002/09/18 57,077 DET: MAG7NCP 2002/09/18 21,230 Some thing like: if ({jobname=AG2PM}then BOLD or underline) Thanks Joe.

I want to convert a whole number (seconds) into time so as to read mm:ss IE. 120 seconds would be 2:00 Thanks Joe.