Search results

I need to convert the following filter expression produced by access in a query to VBA (Lookup_EquipmentID.EquipmentList="A" AND Lookup_EquipmentID.EquipmentList="B")

Thank you sir. It works.

Hello Access Gurus, I want to assign the text of a textbox (in a form) to a particular row in a query. For example, suppose the query has the following output EmployeeID(key) LastPosn ------------------- ----------- 12356 Manager 14567 CEO...

Thank you all. Based on your suggestions, I have managed to implement it using two queries. I have posted what I have done on my other thread. However, I am now trying to get it done using a single query based on the same principle.

Thank you sir, for your effort in helping me. Before I saw your file, I had managed to get the result after following the suggestion posted in my other thread. I found it easier as it didn't have your TOP expression and multiple subqueries. However, I intend to compact my own effort as it is...

You have nailed the problem, sir. But you really lost me with your solution. By linking, do you mean that in the 2nd query, i drag both the original table and the 1st query and then draw lines between the two date fields and ID fields? Please elaborate.

Thanks but I had made the correction already. Didn't work :(

Tried it. The category column is coming as blank

Also, I must mention that userid is not the primary key here. Will this change the sql statement?

Sir, please explain why I need the alias T1. Can I use your statement without using AS?

ID is not the Primary Key. I wrote ID simply to represent an employee. Take it as as employee code. The code is working in Access. I just need to display the category alongside as well.

I have a list of employees with their category promotion dates (A category is better than B and so on. NA implies that the person is not yet categorised) ID Category Date -- ---------- ----- 1 D 1/3/12 2 C 1/2/86 1 C 2/4/13 2 NA...

Also, what is this t1 thing? My table is table1. You are using both t1 table1.

Thanks. Will try it out. But is it really not possible using just the access query designer GUI? I don't want to go into the Sql code window

Sorry for the formatting. I am in a hurry actually. Basicailly userid is 1,2,3 etc and categories are A,B,C,D, NA.

I have a table (say table1) like this in Access 2013 userid Category Date ------ -------- ---- 1 A 1 MAY 13 1 B 2 MAY 14 2 B 1 MAY 12 3 NA 1 MAY 15 1 D 1 MAY 16 2 A 1 MAY 13 4 NA 1 MAY 14 5 C 1 MAY 12 i intend to design a...