Crosstab data entry? (Was: Re: Query question)

  • Thread starter Thread starter Johan Myrberger
  • Start date Start date
J

Johan Myrberger

Thank you! The pointer to crosstab queries made things clear to me!

When you have a crosstab view (in this case of a single table, the
CountryData table below) - is it possible to use this type of view for
data entry? I have tried to use the crosstab query in a form, and found
the properties "Data Entry" and "Allow additions" and set them to Yes.
However I am not able to modify or add data...

regards
/Johan Myrberger
 
Hi Johan,

Johan said:
Thank you! The pointer to crosstab queries made things clear to me!
Click to expand...

You're welcome.
When you have a crosstab view (in this case of a single table, the
CountryData table below) - is it possible to use this type of view for
data entry? I have tried to use the crosstab query in a form, and found
the properties "Data Entry" and "Allow additions" and set them to Yes.
However I am not able to modify or add data...
Click to expand...

Data in a crosstab query are not updatable.

It sounds like what you are trying to do is create a spreadsheet-like
data entry form, and want users to enter their data using this
pseudo-table. If I am correct, this is not a good approach. I suggest
basing your data entry form based on the table (or if more than 1 table,
on a simple select query joining the tables) in which the data will
reside. To *display* data in a wide-flat configuration, create a
crosstab query to pivot data in the table(s), and then create a *report*
bound to the xtab. Search the Help Index for "crosstab queries, reports"
for more information.

hth,

LeAnne
 
A crosstab query is not updateable and therefore can not be used as the
basis of a form.
 
You could create an unbound form for user input. You would need code to pull
the values from your table and place in the controls. Following a "Save" by
the user, the values would be update or appended to the table.
 
Back
Top