Search results

Afternoon All! Quick question, but it's got me stumped so I'm hoping there's a Genius out there who can help me out. What I have is a table "tbl1stAttempt" with my initial data. I've put this into an array "varArray" I have an SQL statement sqlNewValue3 = "SELECT [Patients Waiting] "...

Afternoon All! I really need your help with this one, been going round in circles for ages now! I've got a DB which simulates future waiting lists. This works absolutely fine, it's just extremely slow, 15 minutes to complete process. What I need to do is change from the SQL statements I use...

Hello there! I'm probably being stupid here, but I'm really struggling with two nested For ... Next loops. The DB I have is a waiting list simulator. It has an amount of people waiting in 53 weekly brackets (0 to 52), for each Specialty (19 of them). It takes the starting point from another DB...