Search results

Is there a cursor equivalent function for SQL queries? I want to be able to test each number in a column against something and perform actions on that number depending on the outcome of that test. But for this to happen, i need to one by one test each number in the column by scrolling down...

Hi, I am trying to do this all day and i cant seem to make it work. I have used this IIf([qryCrossTab.Days]<1,"Day 1",IIf([qryCrossTab.Days]<2,"Day 2",IIf([qryCrossTab.Days]<5,"Day 5"))) In the field box where i use Column heading. My result produces a row such as this. Day 1 = 5 Day 2 =...

Hi, I have an access front end and SQL Server Backend. I have created a form for users to enter username and password to get gain entry to the Access Front End. My problem is that the SQL Server Login then requires a UserName and Password. I want to be able to automatically fill in the SQL...