Recent content by MrMitchell

Hey all, I have a database that has a service code field that contains values such as "F*", "X?", etc., and it's formatted in this format for each work order with vertical bars to seperate out the indvidual codes ala: Service Code String I{|F*|X?|TW| I keep running into issues where I'm...

Good morning all, So I'm trying to find a solution to my query not populating fields with zeros for not found records. The problem I would like to resolve is if there is 0 records in the "Total Booked" field, I would like it to populate with 0, rather than ommitting the record. I've been...

Hey all I have the following expression built in a query: weekend: DateAdd("d",-Weekday([scheduled_date])+6,([scheduled_date])) . My reporting week is Saturday-Friday, and the output date is perfect (i.e. weekending date is 6/1/2012, 6/8/2012, etc.) however, it is still including saturdays as...

Lightning quick thank you both so much!

Hey all, I've been lurking around the forum for some time and I'm usually able to find solutions to my roadblocks using the search function, but couldn't find anything, so hopefully you all can help! What I'm trying to do seems fairly straight forward, but can't get the query to work properly...