Recent content by joethehoe

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