Search results for query: *

Thanks

Thanks for the responce on this:) What about a macro?? 1. open and run make table query. 2. rename to ???cd date()?? doesnt allow me to build in the new name field???

Hi dhookom, Then how about just the current date??

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

Thanks pandpp :)

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 =...

FYI: Ive also tried this but no luch either. if ({@GF2:Abandon%Connects}) in {General Information.Job Run Date}= "2003/01/05" to "2003/02/01") > ({@GF2:Abandon%Connects}) in {General Information.Job Run Date} "2003/01/05" to "2003/02/01") then crred

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...

Not a problem, ive been trying to figure this out for weeks. I will try this tommarow and thanks for being so helpfull.

Exactly, GF2: is by date ascending.

average(Table.Dials,Table.Datefield) average ({Combined Call Statistics.Calls Placed}, {General Information.Job Run Date}) Thanks but it is still doing average of details sections. I was hoping for average the (gf2: dials) day dials GF2: friday 94047 GF2: Saturday 53164 GF2...

Data base field

PH: Date Week day(number) Week day(name) Dials GH1: AGE1 GH2: \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\GF2: 2002/12/08 1 sunday 666 GF2: 2002/12/09 2 Monday 123 GF2: 2002/12/10 3...

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

Exactly, I'm using a running total to get the sum of information by day of the week, but it sum's the details section instead of the group footer. So my idea is to take the sum totals and divide by the count of days. Kind of bassackwards but I think it may work. (I hope) Unless you know of a...

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...