Access 97 General Help Needed

[edgeblade]

Hey all,

I have basic knowledge of Access and need a good deal of help trying to get my database to work properly. A friend was helping me with it but he can't help me anymore so I am hoping someone on here can. We constructed a database that I import tables of data into and run a VBA macro that uses the 2 tables to construct a 3rd table with a new data value putting quotes around individual phrases, e.g. "Style A" "Style B", etc. It worked fine for one set of data but I couldn't get it to work for other sets of data. I can post the DB if need be. Any help would be appreciated, thanks.

[Ecniv]

You need to process the files manually to see what you need to code.
Make a flow diagram of the choices you need to make to process the data, then write the code to do those choices.

The Db then can import the data (which you've said works) and process it outputting the results to the third table.

If the processing is not working then you have put a bug in your programming.

[edgeblade]

Well that would be all well and good if I had any clue about VB/VBA. My programming knowledge is limited to HTML mostly. My friend did the code for me...so yeah I have no idea...