Search results for query: *

I have a stored procedure that calls two parameters @Program which asks for a program code input and @MinPo which calls for a minimum Po Amount. The following is my stored procedure: CREATE PROCEDURE MROProgramByDollar ( @program varchar(4), @MinPo money ) AS Select di1.vendor_code...

I have a database where expediting notes are logged by my users and then a date stamp is attached to them. I am trying to extract the latest date for the very last expediting note that was recorded. For example if someone put in one note yesterday and another today I want only today's note to...

I have a field in my report that is a formula. It looks like this: cdbl(Count ({pvmro_orders_over_2500;1.ctlitem}, {pvmro_orders_over_2500;1.internal_po_num})/Count ({pvmro_orders_over_2500;1.ctlitem}, {pvmro_orders_over_2500;1.ctlitem})) I used the cdbl to convert it to a number because I...

I have a report that contains two details sections. I created a second details section to diplsay the exact information as the first with a little difference. Da displays the entire history of orders for a specific part number, Db displays only those records that have been ordered since the...

I need to create a formula that will look at a field ( Expiry Date) and display items regardless of the data type. Unfortunately some of the dates were entered as date/time and others were entered as text. The report is pulling the information from a main frame database where dates are entered...

I have an existing report that pulls the date from a date/time field. Information is entered into a databse and from there the report is generated. The problem that I am having is that sometimes instead of entering the date, people copy and paste the date in and it is captured as text. I need a...