How to update different fields in a table using data from one colu

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

Guest

I have a table with the column payment status. I want to extract specific
values from that column and place them in different columns in another table.
For example.

Table1 : ID PAYMENT

1 accepted
2 denied
3 pending


Table2: COUNTofAccepted COUNTofDenied COUNTofPending

1 1
1


Thanks
 
Hi,



Sounds a job for a (degenerated) crosstab:


TRANSFORM COUNT(*)
SELECT "all"
FROM table1
GROUP BY "all"
PIVOT payment



Generally, we have more than one "group" in the result, but here, it seems
we want just one row. To supply something, I elect to use "all" (as in "for
all the table").


Hoping it may help,
Vanderghast, Access MVP
 
You must log in or register to reply here.

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

Update a field from 1 through 10 6
Query on two tables with matching null fields 4
Have both records from two queries/tables under one Query without related fields. 0
Create a distinct Join 3
Return a value from another table 4
wildcard symbols around a field in a join? 6
Updating one table from another table 4
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Back
Top