Search results

Man oh man... I must be dumb as a door nail. I am trying to update some records in a table named masterIHOP. So, I go to the Enterprise Manager, open it, navigate to the database named BdbCSSQL and even expand the tables and highlight the masterIHOP table. Then I open the Query Analyzer and...

I have a customer that sends me data to be imported into their Access 2003 database in the form of 3 seperate Excel files. Excel file #1 has allot of information about an employee (name, address, start date, last day worked, seperation code, and a number that corresponds to store worked at)...

Is there a way to back-up or export single tables from a SQL Server 2000 database that has literally 100's of tables? I am building a test application using Access 2003 and only need 3 of the tables from the SQL database to build the test. Thanks in advance for your help.

Just to keep anyone that may be following this post informed. Nothing I tried in the report seemed to work perfectly in both versions of the report (Access 2000 and Access 2003). But we finally came upon a solution that works across all versions. We just wrote it into the query that the report...

I finally got the calculation to work. My original formula was good, it just needed one little change. If the field is not showing any value, it is not “0”, it is NULL, the value does not have a default “0” assigned to it. So the zero should have been changed to NULL in my formula. Here is the...

Thanks for your reply... The new formula succeeded in not putting a value in the calculated field if the CreditsThisStatementPeriod field is zero, which is something I wanted it to do, but it stopped making the calculations. Man oh man, I had no idea making calculations would be so difficult.

I have two fields that I need to calculate a total for, but only if both fields have a value in them. The fields are: 1.) ChargesThisStatementPeriod 2.) CreditsThisStatementPeriod 3.) CreditsDueAmount (totals calculated field) Currently I am using the following to try to calculate the totals...

What does "bump a post" mean?

Nope, sorry, still the same result. Could it be that the month (entered as a number) is entered as only one digit instead of 2 digits? Maybe the report or database is looking for 2 digits as in mm/dd/yyyy.

Here is the SQL view: SELECT BenefitCharges.SSN, BenefitCharges.ChargesThisStatementPeriod, BenefitCharges.CreditsThisStatementPeriod, BenefitCharges.CreditsDue, MasterLIJ.SSN, MasterLIJ.LastName, MasterLIJ.[Reason Desc], MasterLIJ.Code, MasterLIJ.ICDateReceived, MasterLIJ.ICDateReplied...

WOO HOO!!! it worked! But, something weird happened. It is returning December for the number 1, and January for the number 2, and then January again for the number 3. Any idea of what's going on with that? Thanks so much for your help... Dave

Forgive my stupidity, but maybe if I explain this to you in a little more detail, then maybe you can give me a little more detail in how to make this work. I have a query named BenefitChargeDetail that this report uses as it's datasource. The name of the field that is returning the number of...

I have a report that returns the month from a table where the month is entered as a number. Is there a way to change the number returned into a word? For example, when the 1 is returned, can I somehow change it to January, or when the number 6 is returned, change it to June... and so forth? So...

OK, I have two tables that have pretty much the same data in them, but, the first table has SOME data that the second table doesn't and I need to get that data into the table that does not have it. Here's a description of what I want to do: Table #1 has about 10,000 lines of data with the...

I tried the above formula, but all I got throughout the report in that particular field is "#Error" Any other ideas?

Perfect!!! Thanks so much for your help. I have another question about reports, do you think I should ask it here, or post a new thread?

Does anyone know how to add a dollar sign ($) before the numbers in a text box on a report short of adding a lable? If the numbers are only 3 characters long, but the box is large enough to accept up to 7 figures from the database, then the dollar sign would be stuck out there in left field and...

Hi Smart, I tried your formula and it didn't like the comma's. I took the comma's out and it still didn't like the formula.

I have two fields in my report that are currencies. The names of the fields are: "ChargesThisStatementPeriod" and "CreditsThisStatementPeriod". I have another unbound field where I am trying to use a formula to add the two fields together. The formula I am putting in the field is...

Has anyone here ever unplugged the battery from their motherboard in order to reset their BIOS? I keep getting an error message saying that the CPU has been changed, but not registered in the BIOS. I can just hit the F1 key and continue the boot without any further errors... it's just that it's...