Search results

  1. G

    update a column with an earliest date from four columns

    Hi, I want to update a column called "end_date", in table "inp_Data", with an earliest date available in these four column: "F_date", or "G_date", or "H_date", or "I_date", If all four columns are blank then update "end_date" to text "No date". Can this be done in a single update query? I...
  2. G

    An update query takes very long time

    Hi, can someone please help. This update query takes very long time to run. Just wondering if this can be achieved with VBA perhaps it will be quicker to update customer field based on criteria in query below. UPDATE tblFinal INNER JOIN tblList ON tblFinal.Type = tblList.Range SET...
  3. G

    Make-Table query takes forever

    Hi there, I have following make-table query within a macro which contains a long list of queries, in Access 2003. Normally when processing small dataset, this query runs reasonably quickly. But when processing large data, this query takes hours and then I often get an error that cannot open...
  4. G

    crosstab output

    Hi there, I have a table with thousands records in Access 2003 database. I want to be able summarise data from 2 fields. These are Country and Durations. I want to count number of durations for each country. I have attached a spreadsheet with some dummy data and an output table that I would...
  5. G

    Data entry form to update a record without overwriting

    I have a table "tbl1" with two columns – clientID, Fault I need a form with 3 objects, combo box populated with drop down list of client IDs, a text box to enter fault details and a submit button. I want to be able to select the client ID from the dropdown list and fill in the fault details in...
  6. G

    Self Join Query ??

    I need some help I suppose is meant to be a self join query - I have a table called tblExport with 4 fields – ID, Date, Destination and Status. I want to be able select records where Date is same, Destination is same and the Status is Success for some IDs and Transport for some others. So I...
  7. G

    Transpose Weekday Columns to Rows

    I have a table with 8 columns titled - Destination, Mon, Tues, Wed …to.. Sun. This is shown as "OriginalTable" worksheet in the attached example workbook. I want to create a new table from this original table that looks like "NewlTable" worksheet in the attached example. So I will have a new...
  8. G

    Calculating time difference from the record above

    I need help to calculate time difference from the record above where ID is same. I have attached an example in excel with this request where I have if statement doing exacly what I want to do in Access. I have a table in Access that has three columns - as below ID, Reg, TimeDiff 66646...
  9. G

    Import multiple csv files into an Access table

    Hi all Can someone pls help me to automate the following import routine. I have a table in MS Access called "Data_Csv" I import a number of csv files manually, files are named as follows - "data Jan07.csv", "data Feb07.csv", "data Mar07.csv" and so on....names always begin with "data*.csv"...
  10. G

    Rank registration events in asc time order

    I have a table "Tag Data" with three fields named – tag_id, reg_time and reader_no. I add 4 more fields to workout - reg_time_occurrence, reader_no_occurrence, previous_reader_no, next_reader_no (see attached text file, where I have these fields manually completed these fields for couple of...
  11. G

    dates/weekdays calculations

    I am new to access/vba modules etc and I am struggling with this. I have attached a simple table in word (call the table Locations) and what I need to calculate in new columns is explained in attachement. I tried doing this in query design but few people suggested It should be done in Modules...
  12. G

    calculate time difference if criteria true

    I have three fields – “Location”, “FirstReg” and “LastReg”. In fourth field I want to calculate “TimeDiff” in hh:mm:ss, if “Location” is “LHR” or “BHX”, leave it blank if “Location” is “MNC” or FirstReg or LastReg are empty. In fifth field I want “1” if “TimeDiff” is less then 1:00, “0” if...
  13. G

    Calculate Weeknumbers

    In excel we could use function "=weeknum(cell Ref)" to workout week number based on a particular date, what do I need to do be able to have this function in expression builder in access 2000? or is there another way to do this? GS
  14. G

    multiple records into one record where common field

    In Access 2000, how can put various records from one table where one field contains same value, into one record adding extra fields. I have attached the example in an attached spreadsheet. First sheet describes what other sheets contain and what I want to achieve. thanks.
  15. G

    line listing records into one record

    Table ChipNo Location(L) 1st Reg(1st) Last Reg(Last) 511 A 8/12 8/13 511 B 8/13 8/14 511 C 8/15 8/16 511 D 8/17 513 B 8/25 8/25 513 D 8/27 8/28 How can I list all the records from above table in one...
Top Bottom