Search results for query: *

I created the same report a while back. SInce I cant attach the rpt. file I will paste the SQL. Looks Messy but it works. Copy and paste this code into a new report that you create so that you can see how it works. SELECT "REPORTS"."V_EMPLOYEE"."FIRSTNAME" || ' ' ||...

I forgot to tell you, if you want to change the way the data formats to example from 10.00 to 1000 then in the derived field you have to use a calculation like this: sum(distinct "REPORTS"."V_YTD_INFO"."YTDGROSS$" * 100) I did this for my gross amount, so if an employee made 3444.23, on my...

I had to format one of my derived fileds the same way, on my field name in the report I had to add this: DEFERRAL_AMT \L9 \PL0 the deferral_amt is the name of my field the \L9 is the lenght of the field the \PL0 means populate with preceding zeros left aligned. so my data comes out like this...

Hey there, you can try this. In the Link the tables box, where you link the employee file#'s for both tables there is a checkbox in the bottom where you can select "Include unmatched records". Did this before and it worked, I just had to play around with it a little. Hope it helps.

look also thread 702-785801

RichardBott, I had the same issue a while back and I couldnt figure out why. I too also added an extra to the form, a combobox. Anyways, reason why I wasnt getting anything was because on that combobox that I added there was a field that I was not including on my query. Query used to create that...

You can try exporting your access file onto your desktop then copying the data from there and pasting it onto your exisitng spreadsheet.