crosstab query in access does not display last results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have developed a table that users can choose from a few fields and input
data, For example name address city state etc. If they wish to update data
they jsu select their name and the field and enter the corrected info (for
display on a web page)

I'm trying to create a crosstab query that displays the name along the left
and the fields (name address etc) across the top and the last value entered
in the corrusponding value. My problem is that the last data does not
display, it is always inconsistent.
 
Would you mind sharing your table structure, some records, desired display,
current display and SQL view?

It sounds like you might be keeping a history of changes but it isn't clear.
 
This is the query sql view
TRANSFORM Last(Updates.Value) AS LastOfValue
SELECT Updates.Team
FROM Updates
GROUP BY Updates.Team
ORDER BY Updates.Team
PIVOT Updates.Field;

I can't paste the update table structure into this reply
 
And "your table structure, some records, desired display, current display"?

Last is not a viable alternative unless you have only one Value/record for a
pair of Team and Field values.

BTW: Value and Field are not good names for fields.
 
If I can only have one value per team/feild I assume this approach will not
work. My desire is to give the teams several "fields" to choose from and make
an entry. If the data changes they can make a new entry. This crostab query
was expectd to summarize the last info they entered.

The table structure is basically
ID - autonumber
Team - they enter ther team number
Field - a dropdown of Owner, Driver, Sponsors etc.
Value - the info appropriate to the field above
E-mail - just for verification

My desire is to give the teams several "fields" to choose from and make an
entry. If the data changes they can make a new entry. This crostab query was
expectd to summarize the last info they entered.

Desired display woud have each team listed down the left side, The differend
"fields" across the top and the last value in the corrosponding square.
 
Back
Top