Recent content by mckenneyj

Thanks Thanks, John McKenney Work Hard... Play Harder

Looking for a way to find the starting and end dates for the previous quarter for any year ex: Today is 6/30/2008. The previous quarter would be the 1st quarter. So I need Starting Date = 1/1/2008 and End Date = 3/31/2008 If today was 1/4/2009 then I would need 10/1/2008 and 12/31/2008...

Is this possible Trying to get dsB to use results from dsA on same report i.e. For dsB something like Select * from dsA Thanks, John McKenney Work Hard... Play Harder

aspx page show results of query from sql server. One of the results is an email field. How do I get that data filed to display as a mailto: hypoerlink. I have already bound it to the URLHyperlink control but that attempts to send me to a URL. Thanks, John McKenney Work Hard... Play Harder

ReportItems! The function can only be used to reference items in the header or footer of the report Thanks, John McKenney Work Hard... Play Harder

3 text boxes do not work because maybe I want to underline just 3 words in the 1st paragraph Thanks, John McKenney Work Hard... Play Harder

I'd like to create a textbox with 3 paragraphs. Paragraph 1 = Bold text Paragraph 2 = Italic, Bold, Verdana, 12pt Paragraph 3 = Bulletted list How would I accomplish this all in a sinlge text box. I am assuming use of the Format function will be needed Thanks, John McKenney Work Hard... Play...

I have a query for the report that returns 100 rows 2 Fields CaseNo CloseDate Of the 100 rows only 32 have a CloseDate Need to perform a count where CloseDate Not Null Thanks, John McKenney Work Hard... Play Harder

The colums in table 2 hold different data Thanks, John McKenney Work Hard... Play Harder

All match records are in table 1 Table 2 houses a subset of table 1 Table 1 has 2000 rows Table 2 has 5000 rows select x,y,z from table 1 where id = 'x' yeilds 1000 rows select x,a,b,c from table 2 where id = 'x' yeilds 500 rows This is because table only holds a subset of the data where the...

sorry blonde moment passed the name of the report in with the function and all works fine please close this thread Thanks, John McKenney Work Hard... Play Harder

so how would I do that Thanks, John McKenney Work Hard... Play Harder

I have a report with the field "MemCat" on it It prints membership dues based on membership category. The code that calculates the dues is in a module ex: Public Function DuesBefore1130() As Currency Select Case [MemCat] Case "Active" DuesBefore1130 = x + y - j...

p.s. To further clarify The first parameter prompt when run should be What is the event field you want to use? The user then inputs OE03 That should tell the query to use the field OE03 and that value = -1 or Yes Thanks, John McKenney Work Hard... Play Harder

I have a table with approx 30 fields 10 of those fields are Y/N optional events people can sign up for. Feild Names are OE01 thru OE10 I need to produce a single parameter query that can reference any 1 of those 10 fields to produce a single report. I'd rather not design 10 querys. For example...