Queries

determining age in peoplesoft query
hi, is there an expression i can use in peoplesoft query to return the exact age of person using the Birthdate field? thanks. ... 3 Jan 2006 16:06

Julian Date
Hi everyone, Trying to display a Julian date in a query. I have the VB code to change a calender day to a Julian, but how would I use use this code in a query? The VB code I have came from the Microsoft Access website and it is; Function CDate2Julian(MyDate As Date) As String CDate2Julian = Format(MyDate ... 9 Jan 2006 07:23

Find next Monday after given date
Hello All I need an expression that will give me the earliest date that is after [res_date] and which falls on a day of the week that is specified at runtime. So given [res_date] values of: 18 November 2005 30 November 2005 28 December 2005 and a runtime value (for the day of the week) of 2 (i.e. I wan... 29 Dec 2005 12:08

Calculating minutes
Hi there, I have a small database which keeps track of downtimes for our manufacturing machines. The user will enter a date and time when the machine went down, and when the machine is back up the user will enter this data as well. I am now working on different ways to look at the data and I'm using the follo... 8 Dec 2005 15:38

Calculate "week-ending" date
In an Access query, I'd like to have an expression that takes the current day of the week (Sun through Sat) and returns the date for Saturday (in "Short Date" format) of that same week. Please advise. -- Thanks! Mona-ABE ... 22 Nov 2005 12:28

Queries
I have many questions, about a project I'm doing. It is a project for my MIS class at school and it is a MAJOR portion of my grade. The main problems I'm havin is in relation to the criteria for displaying records, some in conjunction with the parameter feature. If there is anyone out there who is exceptional a... 22 Nov 2005 10:22

WHERE -IIF ?
I have tried to post this as a WHERE and or IIF statement question. It should be not this difficult a query. I took my main table NameAddr this file contains all of our customers with assigned customer numbers. Each branch has a range of usage between 1 and 9999. Branch 01 only uses 1680 that leaves 8319 number... 23 Nov 2005 23:48

Time calculations
I have been working on a database to track our EOD teams missions. Two of my fields are 'Time Reported' and 'Time Responded'. I have these times set in the 24hour (Military Time) fromat. I am trying to work a query to give me the difference in those times, to calculate 'Response Time'. I would like to then ... 18 Nov 2005 01:13

Calculating percentages
Hi, I'm having a problem that I was hoping someone might be able to help me out. I thought it would be straight forward, but what I'm trying to do is this. I have two seperate queries, and want the total from query "A" divide by total from Query "B" and display the results in percentage. I have tried everything ... 11 Nov 2005 10:21

2 negative numbers subtracted equal a postive number but I want t.
I have a net amount that is negative and another amount that is negative. I want to know the difference of the two and show that as another amount. Just so happens this time - both numbers are negative show on the report the calculated amount is showing positive. I need it to show negative also. Problem is: ... 9 Nov 2005 16:06