Search results

  1. E

    Receive an error in importing excel file into access

    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!
  2. E

    looking for IFF expression in query to calculate total cost

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

    Transpose coloumn to rows with UNION query

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

    Remove some lines from query

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

    How to make a UNION query without same field order

    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?
  6. E

    URGENT: How to create a query based on composite key from two table

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

    URGENT:how to fix the query must have at least one destination field error

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

    expression to look for different category based on first string of one field

    Hello everyone, I'm trying to create a master table that will gather the category of materials and their cost based on the source field. Basically, the category and cost of each material will be different based on the source field. Basically, I am trying to write an expression that will look at...
  9. E

    Urgently need help !!!vba code or query to transpose coloumn to rows

    Hi everyone, I have a table named "Purchase price table" I have a material number and description and location with different price categories for two years of 2019 and 2020. I am trying to transpose price category for each year into rows. here is how I would like to be :
Back
Top Bottom