Search results

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

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

OK, thanks for your help.

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

Excellent, it worked !!! Many Thanks to you and Paul for help.

Paul I am having problems with this query. It runs fine if my table has only few records. But if I have about 1000 records in the table, I get a message that “At most one record can be returned by this subquery”. Is there a way to overcome this problem? Thanks for your help with this. GS

Paul, based on your query, mine looked as the one below and I got the exact results what I was looking for. SELECT tblTag.ID, tblTag.Reg, (SELECT Reg FROM tblTag AS Alias WHERE Alias.ID = tblTag.ID AND Alias.Reg = (SELECT Max(Reg) FROM tblTag AS Alias2 WHERE Alias2.ID = tblTag.ID AND Alias2.Reg...

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

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

Thanks for your help, your query has given me the first two coulmns I was looking for. I only had to add the bit in bold. Thanks again. GR SELECT t.tag_id, t.reg_time, t.reader_no, (SELECT Count(*)+1 FROM tblTag t1 WHERE t1.tag_id = t.tag_id and t1.reg_time < t.reg_time) AS...

Thank you for your help with this. I will try your query on Monday for first two columns and see how it goes. The reason I want to know the previous and next reader number is that I want to establish the flow or path followed by a tag_id. In brief, tag_id is an RFID transponder letter...

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

Hello Bob apologies for keep changing the criteria, I have tried to make it clearer in this attachement. Regards GS

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

Hello Bob, My criteria is getting a bit complicated so I need some further help with this, using same feilds as before I would like to calculate in Success column – If Location is <> LHR or FirstReg is empty then Blank If TimeDiffSay < 60mins AND time in FirstReg on Monday to Friday < 17:05...

Bob Many thanks for your help with this. It worked. Regards GS

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

Thanks Colin

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

line listing records into one record Nick Thank you for this. Yes, at this stage I only want to know where and when last entry took place for each chipcard_id at 4 types of locations. But if I do want to know any other entries, I can add another type for example foreign office 1 and foreign...