Search results for query: *

Hope someone can help i have the following code PARAMETERS [Between [forms]![frmPreviewReports]![txtStartDate] And [forms]![frmPreviewReports]![txtEndDate]] DateTime; TRANSFORM Count(qryClusterA.ClusterXfers) AS CountOfClusterXfers SELECT qryClusterA.Interval, Count(qryClusterA.ClusterXfers)...

I am trying to write a module with the following code If Name like '*119*' Then CorrectName = "Macclesfield " & Name elseif Name like '*118*' Then CorrectName = "Stockport " & Name End If i need to run this code for about a 1000 different outcomes but the code is stopping and highlighting the...

Hope someone can help i have the following code that returns any data before a space in the name field Left([Name],InStr([Name] & ' ',' ')-1) i also have the following code that returns any data before a "-" Left([Name],InStr([Name] & "_","_")-1) i was wondering if it would be possible to...

Hope someone can help I am trying to run the following delete query SELECT tblAlternativeNetworkCallDetail.*, CDate(Left([StartDateTime],10)) AS Expr1 FROM tblAlternativeNetworkCallDetail INNER JOIN tblMidTermAnsPoints ON tblAlternativeNetworkCallDetail.TAD = tblMidTermAnsPoints.TAD WHERE...

I have the follwing code to fill in any blank records i have in field1 Set db = CurrentDb() Set rst = db.openrecordset("tblInitialAgentCcsData", dbOpenDynaset) rst.MoveFirst Do While Not rst.EOF strField1 = rst!Field1 rst.MoveNext Do While IsNull(rst!Field1) rst.edit...

I hope someone can help, i have used the following code from thread 705-892728 Dim ImportFile ImportFile = Dir("C:\Program Files\Alcatel\A4400 Call Center Supervisor\Excel\DAILY\Agents\18_09_06\*") Do While ImportFile <> "" DoCmd.TransferSpreadsheet acImport, 8, "tblInitialAgentCcsData"...

I have a list of customer telephone numbers (field Name "CLINumber")in a table what i need to be able td do is to confirm form the inital std code what area the call should have been deliverd to. so i want to set up a module to check each record for example if the customer number is 01132151239...

i hope some one can help i am pulling my hair out with this one I have the following code DoCmd.TransferSpreadsheet acImport, 8, "tblInitialQuoteData", "H:\Retail Network\Public\0800Plan\Ops Team\Non Motor & Internet\NSU man tracking V6.XLS", NO, QuoteDatabyName when i run the code i get run...

I hope someone can help, i have the following code on the open event of a form to find a specific record Me.Recordset.MoveFirst Do Until Me.Property_Ref = Forms!frmPropertyBasicDetails!PropertyRef Or Me.Recordset.EOF Me.Recordset.MoveNext Loop thios works fine if there is a...

I have been sent a table that holds all our call details by day i need to be a ble to check each record and if the next record in the table is the same then i need to update a field in my table [DuplicateFlag] with the word "duplicate" i have come up with the following that i seems to work...

I hope somebody can help, i have a table that has a number of fields but for this query i only need 4 fields, they are Date CLI Less60Flag Greater60Flag The problem i have is the table contains the number that a customer contacted us on (CLI), what i need to do is count the total number...

I hope someone can help an point me in the wright direction. I have been asked to build a database that will automatically check a specific location on our local drive (H\OvernightReports\AutoStats\ for a report that can be generated at any time and a number of reports can be generated...

Hope someone can help I currently download some data extracts overnight into a location on my C drive, i need to know if there is a way on the timer event at 05:00 every morning i can move these files into another location using access any ideas would be appreciated

I get sent 30 text files daily that i need to import into a table (tblIndividualTelephonyStats) each file is named different ie the staff members name. the problems, at the moment i am having to import each file and then update a field (name) in the table with the name of the file (staff name)...

Hello all I need to remove the first 2 characters and the last 4 characters from a string can some tell me the best way to do this please

I hope some one can help I currently get sent a table daily that has a field (Trans date)that is formated as text and has dates in the format 23May2005. what i need to be able to do is convert this date into a correct date format ie 22/05/2005 so that i can query the data using a calender control.

I have this very simple union query .... SELECT [Department],[17/05/2005] FROM [qryVitalStatsCallsOffered] UNION ALL SELECT [Department],[17/05/2005] FROM [qryVitalStatsCallsabd]; the problem i have is the field [17/05/2005] is a date field in qryVitalStatsCallsOffered and depending on what...

I have a table full of deciaml hrs. I need to be able to return all data from the right of the decimal place (if there is any decimal minutes if not return nothing) so that i can multiply the decimal minutes by 60 to give me true minutes Hope someone can help...

I was wondering if some could help me with this one... I have a datapage that i refernce to feed my final worksheet, the problem is the data runs from top to bottom on my on my final sheet ( a format i van not change) and left to right on my datapage. The problem i am having is on my final...

I hope some can help.. I have a query that has 17 columns i was wondering if anyone knows of a way that i can transpose the data in a similar way that you can in Excel?