Search results for query: *

I am working on a Windows 2000 box with SQL Server 2000. I have a DTS package that I want to create that I want to run the first of every month. The goal I am trying to achieve is that I want it to automatically name the table I am copying with the day before's date. So, if I was running it...

Hello All! I have a very simple query in Access 2000 that I run a search form off of, with the end result being a report. The form searches for From Date, To Date and GL#. The GL# is entered into the database by the users as 0000-0000-000 (except with numbers of course). But, now they only...

This seemed so easy to me when it came up and a suggestion and now that I have tried actually doing it, I can't figure it out! I have a "search" form and it is a search by last name. I have 5 forms but they all are pulling from one table. So, I have one main table behind this one search form...

I have a button for a search form I made and I am very VERY new to writing in VB. In the “On Click” event procedure, I want to do an If Then Else statement, like this: If [FormType] = “Back Office” then OPEN frm Main Else If [FormType] = “Accounts Payable” then OPEN frmAccounts Payable Else If...

I have a database that I am creating in Access 2000. I have 1 Main table and 5 different forms that provide data to this “Main” table. Lets say the tables are BackOffice, AcctsPayable, Assets, DollarLoss, and FeeLoss. Also, within the Main table, I have a field called “FormType” and that is...

Hi, I work for a small credit union. I am trying to create a formula for a report that summarizes our loan underwriters' response times. The data needs to be limited to applications from only 2 out of several underwriters and must contain all status records for those applications that are...

HELP!! I have a report that I have created and am running into ONE problem. I have this field called "StopCode" (which contains many values). I have another field called "StopCodePos" which stands for what the position of the StopCode is.. as in 1 or 2. So, right now it...

I need HELP!!!! I have 2 fields I need information for and the report is showing only info that is from both tables - for example: I have a field for "Joint Names" and "Legal Names" - It's only showing records where both are true. How do I get the records to show that just...

Hello.. I am having a problem with having no page header in my subreport. I have a report header but need a page header because the subreport flows onto more than one page. It doesn't even give me the option of inserting a page header. Is there something that I am overlooking??? Any help is...