Hello I'm looking for help with queries in Access. It's diffucult to explain- everything is explain in car.xlsx in zip file.
.
Thank you for any help.
Methis
cars.zip
Hello I'm looking for help with queries in Access. It's diffucult to explain- everything is explain in car.xlsx in zip file.
.
Thank you for any help.
Methis
cars.zip
Consistency in structure is critical when parsing data.
Your data can have any number of cars in the Notes field.
Means need VBA custom function to accomplish this using an array and Split() function.
Alternative is to export the records from [data] to Excel, parse the car data to separate columns using the comma as the separating character. Import records back to Access. Access query can then handle splitting up each car's info by using string manipulation functions - Left(), Right(), Mid(), InStr().
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Access and Excel are different animals. You need to design your database. Having a number of codified strings in one field screams out a need for Normalization (see http://support.microsoft.com/?id=209534).