Queries

[jeannier1975]

Question: I have looked everywhere and even paid someone to look at the issue I am having. 1. I have a routine that deletes the table data and loads new datatable that is download from an SAP application. the issue i am having is that when i run the old data in the queries i get the correct calculations and percentages. But when i input or import new data after the old data has been deleted my queries are not calculating the data percentages correctly. I would gladly pay someone to look at it since i cant seem to find a answer after looking at several resources. Since my Database is too large to download can you look at here. You can download it from address: http://xxxxxxxxxxxxxx

[twinnyfo]

jeanier1975
the issue i am having is that when i run the old data in the queries i get the correct calculations and percentages. But when i input or import new data after the old data has been deleted my queries are not calculating the data percentages correctly.

The impression i get from this statement is that this "non-working" status happens continually? If so, how do you get it to work in the meantime, so that next time you do a data download, the calculations do not work properly? The answers to some questions might help:

• Are you deleting the data in the table or are you deleting the table and then re-attaching new data?
• Exactly what is it about the percentage calculations that are "not working correctly? This will help us understand what the problem might be.
• Do you have the data types properly set for your tables?

Let us know about these things and we'll be glad to take a look.

[jeannier1975]

Answers i have the data in the table deleted.
The calculations are not returning the correct numbers in the database after i run the parameterf with the parameter dates.
Yes i have the data types set on my database that why i attached the upload link of my database.

[twinnyfo]

jeannier1975:
The calculations are not returning the correct numbers in the database after i run the parameterf with the parameter dates.

This description is not helpful. You need to explain yourself much more clearly if you expect us to be able to figure anything out with your DB. We can only assume that you are expecting one calculation but receiving another. You have to explain what you expect to happen versus what is actually happening. This is not too much to ask.

Also, in general, do not post a database to our forum unless you are specifically asked to do so. Many of us work on Bytes from work, so we are unable to download a DB anyway.

[jeannier1975]

i do appologize i just dont know how to explain what the issue is because i cant troubleshoot the mater

[twinnyfo]

You do realize that what you have described is like taking your car to a mechanic and saying, "It doesn't work. Fix it!"

Does the car not start? Are the tires flat? Is it out of gas? Is it making a weird noise?

You've got to help us out with this, otherwise, we are unable to assist you.