Search results

I just left it as the file name, this worked the first time i did it now that i have moved both the database and the file even though they are in the same directory as one another still it doesn't seem to find it.

Ok I have the macros working it was a asimple case of creating specifications for each table. My next question is how do I set a path for that file as it continually says file cannot be found when I transfer the database and files even though they are both in the same directory.

Hi if you find anything about how to do this could you please tell me as I am trying to do the same thing at the moment and am having difficulties.

I import all the field names

I am currently attempting to create a macro to import a csv file to an already existing database. When I do this through a manual import there is no problems however when i create the macro it says that I have an invalid field name, so can someone please help as I am lost. Thanks

Pat: Thanks but got it sorted thank u for all your help

Thanks guys but got it sorted seems Access has a 255 character limit for expressions so I figured it out.

Just an update i now have the query working for 4 nested iif statements but can't get the fifth any idea?

Can somebody please tell me if there are any problems known with writing iif statements inside each other in QBE as I am coming up with a syntax error saying missing operator and i don't know where. Thanks

Pat: If this is of any help here is a small listing of the way tables are at the moment tblCust: Customer Number Name Discount Type tblItems: Item Number Description Base Price TbleItemsDiscount: Item Number Disc A Disc B...

Pat: So are u saying have just one field with each level of discount or have 5 seperate fields as different products also have different levels of discount not just on the customer.

I am currently trying to create a case statement to select one of 5 different fields depending on the result of another field from another table. I am inexperienced at VB but have reasonable Access skills so any help would be greatly appreciated.

aqif Thanks but it doesn't seem to work. What I currently have is a customer type and then 5 seperate fields listing each customers discount for an item depending on what type of customer they are. Therefore I cannot create a relationship from customer type to each discount as it would be...

Hi I am currently designing a query and I need to be able to select a different field from one table depending on the value of another table e.g if the customer type = a then select price 'a' if customer = 'b' then select price 'b'. I have tried both if and case statements and have had no luck...