Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Adding data to a Crosstab Query

Status
Not open for further replies.
Matf

Matf

Programmer
Aug 28, 2003
23
US
Does anybody knows of a way to display data in Crosstab mode but being able to update the fields?
Thanks
 
Sort by date Sort by votes
Can't be done to a crosstab. You can work around this by places the values in either an updateable table or unbound text boxes on a form. Then when done with the updating of the table or form, run a procedure to update the original tables that the crosstab is based on.

Duane
MS Access MVP
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

C
  • Question
Query expression negative to a 0
Replies
6
Views
381
dhookom
dhookom
serino
  • Locked
  • Question
Help with a Query. 1
Replies
13
Views
879
strongm
strongm
breezett93
  • Question
Query takes 30 seconds - 1 minute to process. Trying to rework it to take 5 or less
Replies
5
Views
161
Chriss Miller
C
btamsgn
  • Locked
  • Question
how to create a crosstab query 1
Replies
1
Views
2K
dhookom
dhookom
JimStrand
  • Locked
  • Question
Crosstab query - returning 1 record per week instead of 1 record
Replies
1
Views
791
JimStrand
JimStrand

Part and Inventory Search

Sponsor

Back
Top