Search results for query: *

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

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

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...

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...

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...

Can someone tell me the syntact for using NOT LIKE Here is the snipet used if {CASE_FEE.FDICN_DESCRIPTION} LIKE "RC" then "Replied Correct" else if {CASE_FEE.FDICN_DESCRIPTION} NOT LIKE "RC" then "Reply Incorrect" I know I could leave the seconf line off but need to incorporate for furture...

I have a report that displays info for users based on dynamic queries. That user info is in misc address fields. The report also displays 4 paragraphs of information. The database is converted to mde files for use by my customers so they can't screw up the code. The problem is the 4 paragraphs...

I have a table x with 2 fields Case and Amount 27,000 records Table is formatted as Case Amount AAA2005-00000 200.00 AAA2005-00001 100.00 AAA2005-00005 1000.00 AAA2005-00010 500.00 BBB2005-00000 100.00 BBB2005-00002 25.00 CCC2005-00000...

Building a small barcode scanning database User Scans barcode into text box control on form Length of complete scan is always 9 I need the control to automatically: 1 sense when it is at 9 characters in length 2 auto save the record at that point 3 blank the control (Null) 4 move to new record 5...

In the middle of a Brain Cramp Seems I have forgotten how to do this I have defined a Module named basCompanyInfo In the module are several Public Const Public Const AName = "xyz" Public Const AStreet = "123 easy street" Public Const ACSZ = "city, st, 11111" Public Const APhone = "PHONE: (555)...

This has been happening since Access 2000 and now through 2002 and at present 2003 This application uses 2 DB's 1 with the data (Backend BE) and one with all other objects (Frontend FE) Create a Report formatted for default printer Compile the Frontend into an MDE All aspects of application...

Need to delevop a query that will take records where "Status" = Current and concatenate the "Designations" for each "UserID" into a single string i.e. final outout for table below should be: 456 ABC, CBS 345 CBS, XYZ Table with 3 fields: UserID, Status, Designation 123 Lost ABC...

Can anyone tell me what is wrong with this statement. If I comment out the IF stmt then the case works fine. Private Sub Date_AfterUpdate() Dim ResultYear As Integer ResultYear = DatePart("yyyy", Me.Date) If Me.cmbCycle = Null Then Select Case ResultYear...

The tables will contain record with dates over several years I want all dates returned that are within 10 days of the date entered This works: >#10/14/2004#-10 This does not: >[Enter Date]-10 I need the user to be prompted for the date to enter Thanks, John McKenney Work Hard... Play Harder

Form source is tblXYZ Storage field is ConfID external source tblConfInfo with matching field name ConfID and serval other currency fields "amtdue", "discount", "firsttime", etc... ex: tblConfInfo amtdue = 50.00 discount = 20.00 firsttime = 5.00 Button on form named btnCalc with underlying...

Web does not use frames I have a 3 rows by 2 column table om page1.htm I need abc.pdf to open and display in cell b2 abc.pdf if in the same web Then need: page4.htm residing in an external web to display in c1 Thanks, John McKenney Work Hard... Play Harder

Table has composite key PeopleID Integer & SeminarID Integer The Form has you select an individual with a combo box bound to peopleid It then has you select a seminar to attend using another combo box bound to seminarid On the afterupdate event I need to check and see is any records already...