Search results

whoo hoo! has anyone told you, you're a genius? =)

hi, i was wondering if anyone knew how to create a query that sorts information by months, from the beginning of the current year all the way to the current day. so, for example, if i opened the query now, it would give me a total for January, a total for February, and so on, until it comes to...

whoo hoo...never mind...found it out... thanks! =)

hmm...not quite understanding this procedure...(not you, it's my stupidity ={ )... let me put this in another way...if the stock doesn't show up on any of the transactions on the transaction table, then it'll be listed on the report. it uses the second table (the stock table) as reference as to...

hi, i need to make a query of stocks that HAVEN'T been traded within a time range. There are two tables, one telling me trade transactions, and another telling me what trader is responsible for what stock. if one of the stocks on the second table doesn't show up within the time range for the...

lol...i thought so....i've been to newcastle and it's quite a snazzy place. well...it was worth a shot... btw, newcastle ale rocks! =P anyway, i was playing around with the database...and no, this isn't the only report that doesn't show. you see, i need reports for three categories of...

yargh...it still doesn't work...seems like the code is cursed... =P i'll post the code...hope it isn't TOO confusing. btb, i notice you're from newcastle. this is a long shot, but would you happen to know an Andrew Done there? he goes to uni there. For the code: concentrate on how it gets...

actually...i created a button with only the simple command: DoCmd OpenReport DocName, acPreview and the subreport total shows. so, that does mean the checks that the button runs through affects the report...but i have no idea what it could possibly be since none of the checks actually change...

well it runs through a series of checks first by opening up a data table as a recordset, but i doubt that affects the report since no changes are made. the main command line is just: DoCmd.OpenReport DocName, acPreview. thanks! =)

hi, im designing a report that gives transaction details for an individual person within an inputted date range. Within this report at the report footer, I've inserted a subreport which is supposed to be giving the month to date (beginning of current month to today) totals for that person. the...

=IIf([rptMgrsSummaryToday].[Report].[HasData]=True,[rptMgrsSummaryToday].[Report]![Total],0) I found it out. put that in the control that carries your total out from the subreport to the main report. Bascially it makes all blank record sources = 0. genevx thanks for trying! =P

Hi, I have a subreport and I want to calculate the totals for it. however, since it is connected to the main report, some fields might not always have data for the subreport. I'm guessing that's what's causing the total not to come out if there is no data for the field. I did a quick search...

thanks! added the subreport and it works fine! =P

found out! it's: DateSerial(Year(Date()),Month(date()), 1) thanks for the reply! genevx

hello all, i'm trying to make a text box default to the first day of the current month and year. Anyone know what i have to toggle with or write? =) genevx

i just don't seem to understand why when I put Sum(Com) in the report footer of my subreport, it doesn't give me the total of all the amounts, but rather just returns me the value of each individual amount. =( please help! this just seems like such a simple thing access should be able to do.

cool...but how do you use the hasData method? don't seem to understand the syntax...=P and also...for some reason when i calculate percentage for the commission on the subreport: Sum([Com]) / [SumAll], it takes the SumAll from the main report rather than the subreport. I'm so confused...=P

if the above was a little confusing...let's just put it this way...how do you calculate a grand total from a subreport and then send it out to the main report??? I know this has GOT TO be simple...i'm just too stupid and tired to find out =P

just wondering...but how do you calculate the totals from subreports and sending them out to the main report? i'm having trouble doing that since it makes each record from the subreport an individual report for some reason.

Hi, I've created a report for amount totals grouped by exchange type according to a date range entered by the user. Within this report, I've created a subreport which reports the amounts for each exchange type for today. However, I cannot get a total sum for the subreport because it takes each...