Search results for query: *

I receive emails every half hour to indicate that one of our servers is running. When the server goes down, it often goes unnoticed for hours and then we realize that we did not get the emails. I would like to write a module in access using vba so I can monitor the emails that get routed to a...

I am trying to merge two pass thru queries. One is parts and part attributes, the other is calculating a rolling 12 months sum of sales. Here is the code for the one summing the sales: SELECT z.itemnum, sum(case when z.yr = year(sysdate) and month(sysdate) >= 1 then z.actualusage_01 else...

Here is the code i am trying to wokr through. All seems to work fine until I incorporated the iCi table. I cannot figure out how to set up the joins in the right order. Can anyone please help? SELECT i.itemnum, i.description1, i.udindx3 AS...

I am a bit stuck on converting some local Access queries to real SQL as I am still learning SQL syntax. Can anyone assist? I butchered it pretty well below. Any assistance is greatly appreciated. I am most stuck on going from Access "Iif" to SQL If. SELECT TOP 120 w.loc...

For anybody that struggles to read the SQL that Access generates, here is a great website that will format your SQL for you: http://www.dpriver.com/pp/sqlformat.htm Hope this helps, Nic

I am trying to improve some queries by doing the subselects against the same table (but referencing other records). Something is incorrect in my syntax and I have tried a bunch of variations of the referenced table and nothing seems to work. Can anyone please help? The goal is to get every field...