Search results

I tried to import an excel file from external data option in access, after following importing steps, in final steps I received this error message

Hi All, I get below message when import an excel file into the database: an error occurred trying to save import/export specification Your help is greatly appreciated!

Thanks Gina for your response. I will try to use this format. In regards to my question for my query I ran into different problem. in my table, the volume for each material get repeated as the category lines is added for each product.should i use distinct criteria to only have one volume for...

Where is the Forum, I tried to open the link you have copied,but can't find the post with solution related to my question. In regards to normalization, I have read about it, but I still don't understand how I have not practiced proper normalization?

Thanks for your answer. but I need to show my data on a monthly basis but the cost will be a quarterly basis as It shows in the attached file.

Sorry, I didn't know the policy about crossposting. I posted on two forums as I have a deadline to make for my work which is very important. that's why I couldn't wait days to post on another forum. Moving forward, I will practice crossposting. I hope someone will give me an answer as I need...

Hi, Here is code: SELECT VolumeTblwithQuarter.Destination, VolumeTblwithQuarter.Material, VolumeTblwithQuarter.Field1, VolumeTblwithQuarter.Source, VolumeTblwithQuarter.Month, VolumeTblwithQuarter.Quarter, VolumeTblwithQuarter.Volume, [VolumeTblwithQuarter].[Volume]*[MaterialTbl].[2019...

Hi everyone, I need to have write a formula that will calculate rate based on quarter. Here is the snapshot of 3 tables I have. I have tried to left Join VolumeTble with MaterialTble based on source and material. meaning if the material 123 is coming from Toronto take the rate from MaterialTbl...

Hi June, Thanks for your reply. It is different since I want to layer this into the existing field instead of creating a new field. Here is what I have comeup so far which is working but the "where"clause is not working SELECT Location, Product, TableABC.Category & " - Lane rate" AS...

Hi everyone, I'm trying to transpose columns to rows into some existing field, which doesn't turn out to be the result I am looking for. based on my code, the 2019 late rate or 2019 Rebate or 2019 Fee will create a new field instead of layering into the existing field called "Category". here...

no, the union query is closed

yes, table b has exactly 4 fields. how about same conditions? basically, i don't want to include rows that has syrup in field 2 or field 4 has number 1 .

Thanks for your response. I got this error message again while making a select query of two tables. First 10 fields i chose in design grid are from table A, and the rest are from table B by computing with one fields from table A. I realized that I needed to change the name of one of the field...

Hi everyone, I have a make a union query which I am trying to union two tables together. In one of the tables, I don't want two things to be included in two fields in Table A that contain certain criteria. Here is my SQL which is not working and I get this error" Undefined function "Where" in...

Hi everyone, I'm trying to make a union query of two tables but some of the fields are not in same sequent. Is there a way to create a union query with these two tables?

From table A here are fields Delivery location,location desc,material,material desc,volume,month,quarter the composite key for this table is Delivery location and Material From table B here are fields, Delivery location,location desc,material,material desc,month,origin the composite key for...

Hi everyone, I'm trying to create a query by joining two tables based on their composit key. I have tried to build the composit key for two tables. However, in the design grid the name of composit key for each table doesnt appear so I can join them?

Hi All, I am trying to make a master list by joining two tables based on the "Source" and "material" field. this two table that I am trying to join are the result of creating make table from union queries by writing following code: qryTable123: SELECT * FROM Table1 Union All SELECT * FROM...

I am building this master table to get the cost for each material based on delivery location and origin location as the type of material will be different based on origin location. From this master table, I calculate total cost of each category for the year. I hope I was able to explain the end...