Search results

I'm probably not going to implement this computed field but I managed to work out the syntax so for reference. TSQL - SQL Azure ALTER TABLE ProjectManagement ADD FutureorPast AS CAST ( CASE WHEN TargetDate > GetDate() or TargetDate is Null THEN 'FUTURE' WHEN TargetDate <= GetDate() THEN 'PAST'...

Doesn't annoy me but I do notice it. I wouldn't choose it if it could be removed.

I can see why you are nervous Jon - I m not a massive fan of mobile for this kind of thing as I very rarely access it that way. Also there is quite a bit of loss of detail on the stats of the individual users on the left hand side. Might be configurable - don't know but you don't get an instant...

Thanks Maj - didn't really make my question clear. Its an SQL Azure database linked to an ASP.NET application. The amount of data is insignificant - we are talking about 5000 records growing at about 100 records a month. I am just getting to grips with functions in SQL and find computed...

In this particular case I will be referring to it in multiple views and forms so if I design it once I can reduce the complexity of a number of queries. You wouldn't happen to know? If you persist a computed column will it re-calculate when the record is updated?

Just solved my own problem. Its great that articulating an issue helps to more clearly define the problem leading to a better investigation towards a solution. One of the reasons why forums are soooo good...

Postscript I guess I can use something like the case statement put it in a function and then reference the field to the function? https://www.w3schools.com/sql/sql_case.asp

Hi all I am trying to create a computed column as per Computed columns But I would like to use a conditional statement to create the value IF datefieldvalue is null or >= Today computedfieldvalue = Future Else computedfieldvalue = Past END IF Has anyone any pointers ?

This is the vba I use to get lists of files from a directory so swapping out the rs. stuff with some kind of name code as per Cronk should automatically work through a whole directory although a function like that is pretty powerful make sure you make a backup of that directory before you do it...

I'm with everyone else I would never put image files into Access - although its an option I have always ran out of space incredibly quickly doing this. PS - if you want a cheap option for a SQL server Postgres is excellent - open source and likely to be able to cope with anything. I suspect...

Colin if you are looking at wordpress - OceanWP have a free offering which seems quite good. I don't use it on my blog I use default 2016 theme but that was more because of timing. I have done OceanWP for a client and so far I have liked the balance of flexibility and control that it offers. It...

Hi Colin Others people code always looks way more interesting than your own! I will set up a links page and let you know. Thanks for your work. Update : I have a links page as well now.

Just tried it in MS Access 2003 and it seems to work. Seriously for me Access 2003 refuses to break - I can still connect to Azure with it.??? In some ways maybe this is a good thing maybe they will test better before release especially for MS Access.

Hi Colin I've been writing and collecting some simpler functions here which people may find useful. Its somewhat simpler than many of your links. https://rounduptheusualsuspects.org/?cat=16 I figured out how to create SQL queries and put them in a table and then run them from a table. Its...

Sorry I would be in the same situation as you if I had those limitations. Posts script : I would have another go as Gasman states below

Looks like you might be stuck. If you can't run code you can't run code... For anyone else https://rounduptheusualsuspects.org/?p=1386

Thanks guy - that counting everyone that is lower sounds so deceptively simple wonder why I couldn't have thought of it myself...!

I've had some very limited experience with this. I did manage to use VBA to navigate to multiple websites and enter a planning application in a field and then submit that for a search. I am guessing it could be adapted for more significant input and submission. Have a look at this Navigate to...

Another discussion that might be useful https://stackoverflow.com/questions/4463116/use-access-sql-to-do-a-grouped-ranking

This looks like what I was looking for will just have to convert to MS Access http://sqlfiddle.com/#!18/4d6b4/1