How to use a data type that is stored as a record

J

John

I have two tables; one stores just data, and one stores Field
information.
In the first is a text field that in reality stores the values for
either text of number fields.

In the second I have the field names and the datatype of the field,
all stored as records.

Joining the two tables and then using a crosstab query, I can take the
field names from the records and place them as column headers, and
take the data from the data table, and place it in the values under
the column headers.

Problem, how do I convert the text values stored in the data tables
into their correct datatype?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format change in merge data - Bold formatting after a comma 0
Transfer data between two tables 3
Adding data to MS Access from csv file 0
How to use/create code in MS Word to calculate age? 0
Finding the proper style field and the numbered paragraph value within the style 0
Split form 0
Finding the right style field in VBA 0
Creating a Search using a combo box and then creating a report. 4

Top