Recent content by Qualinwraith

Ok it worked but the value returned is a tad unreadable with all the exponential values and all. any way how to make it more readable? is there such thing as formatting?

Thanks a lot Namliam, that cleaned the mess up. I kind of need to add an additional column to this thing, one that will allow me to calculate the tiem difference between the first date column and the last date column. Do you know how that is done?

This is my current SQL statement. Note that this one is asking me to enter the values manually instead of taking those found in the columns. SELECT tblMoscow_Transactions.FK_PledgeID, Max(tblMoscow_Transactions.intStatus) AS [Last Status], Min(tblMoscow_Transactions.dtmStatusDate) AS [First...

it did help but unfortunately since I'm generating the colums with the dates out of a query, when I run the whole thing it is asking me to insert the First Date and Last Date manually and not accepting the existing columns

I have a query that is generating two colums, one the states the Start Date and the other that States the End Date. I need to display another column that displays the time difference between the two. Any ideas how?

select FK_PledgeID, max(intStatus) lastStatus, min([dtmStatusDate]) firstdate, max([dtmStatusDate]) lastDate from tblMoscow_Transactions group by FK_PledgeID This is the sql statement optimized for my table yet I am getting a 'Syntax Error 'missing operator' in query expression...

I have a Transactoin Table that holds the following fields: TransID (*Primary Key Numerical Value) OrderID (Non Unique Number Value, One Order can have multiple Transactions attributed to it. Status (Numerical Value ranging from 0 to 32, each is a different phase in the life of a transaction...

Finally I managed! thank again for all the help and patience!

its telling me that the expression entered is too complex and that I should try to simplify it. What do 'I need to type in a a field name?

How do I have to specify this field in the Query creator? it's giving me a few bugs.

When I said divide I meant having two sections with the first listing the positive and the seconds the negative ones

Thanks a lot and seasons greetings from Malta! It worked successfully! Would it be possible to divide the positive amounts and negative amounts when making a report view?

I've opened the file and the sum of positive values and negative values is empty. What formulas do I need?

I need to make a coupel of statements that display the total (sum) of negative amounts and positive amounts from a single list of results which comtains both negative and positive values. The two answers need to be displayed in the footer of a report

I have a report of all the earnings and expenses of several transactions from several departments, organized with the total earnigns of each transaction type. The results are both positive and Negative. I need to Separate the Report in two sections between the Positive and Negative Values Work...