Help ¡¡¡

aaguioli

Board Regular
Joined
Mar 19, 2003
Messages
61
Hi,

I'm using spanish access.

When I use Excel, there is a funtion like this:

Sumar.si

I'd like to know the same function to access, could you help me?

I'd be more thankful if you response in spanish.

Best Regards.
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
Bueno, recibí este mensaje de Corticus, estoy traduciéndolo tratando de ser lo más "fiel" posible, pero no soy muy experto en Access, así que no garantizo la traducción:

Corticus said:
They need to create a new query, and add the table that contains the field on which they want to sumif(). Add any fields of interest to this query. Under the field on which they need to apply criteria, add criteria in a similar manner as Excel like >3 or ="text".
Now make a report referring to this query including this field, and add a textbox to the report footer. Type =sum([yourfield])
Replace 'yourfield' with the field of interest's name.

I posted an example here:
http://www.theillumni.com/posts/sumif.zip

Traducción
Necesitan crear una nueva consulta, y añadir la tabla que contiene el campo en el que quiere basar el Sumar.Si. Bajo el campo que se quiere aplicar el criterio, añadirlo de manera similar a Excel como >3 o ="text". Ahora se debe hacer un reporte refiriéndose a esta consulta incluyendo el campo, y añadir un Textbox al pie de página del reporte. Ahí se escribe =sum([sucampo]) Remplace 'sucampo' por el nombre del campo en interés.

Puse un ejemplo aquí:
http://www.theillumni.com/posts/sumif.zip
 
Upvote 0
Another question

Well, I understood what yuo told me but I've already made that, let me tell you what I made.

I have a table
I have a query


I already made my report referring but it is made with the table, so, How can I include a query's field if my database is from table???

Best regards.
 
Upvote 0
Hi aaguioli,

Make a query with the same fields as the table.

E-mail me if you'd like.

HTH,
 
Upvote 0

Forum statistics

Threads
1,223,532
Messages
6,172,881
Members
452,486
Latest member
standw01

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top