Search results

Is there a way to make a sumif sum multiple columns? For example I could do =sumif(A1:A5,"Z",B1:B5)+sumif(A1:A5,"Z",C1:C5) would work if I wanted to sum columns B and C. This formula gets pretty long if I want to sum columns B through BB. Isn there a better way to achieve this? I only have...

I am trying to create a form to enter data in a table. I would like to make it pull in info from a switchboard. If the record already exists I would like it to find it and allow me to edit the info. If the record doesn't exist I would like to be able to add a new record with the data input...

I get tasked to use access very infrequently but now I have been asked to create a database. I am struggling with combining 2 tables. I have different data on each table however I do have a unique Identifier. So on table 1 I have Bud, his height, weight, etc. On table 2 I have Bud his home...

I would like to build a query where it retrieves data from 4 seperate comboboxes. However I want to give the user the option of leaving the box blank and treating a blank as a wildcard. How do I setup the query to treat a blank as a wildcard?

I have created a small database that will have no more than 500 records. It is located on a LAN. It works fine for me, I'm in the US. However I have users in India when they try to use it, it is unusably slow. I really don't know anything about networks. I've looked at tips for speeding up...

We have an access database on a Lan drive. I made a copy of it on my desktop. I was playing with user level security with the copy. I deleted the copy on my desktop. Now when I open the the original on the LAN drive it asks for a password. When other users open the LAN version they don't...

I have a form that with a combo box that is populated by a query. The user can select a value from the combo box which then opens a form filtered by the chosen selection. However I have noticed that the identifier field gets changed when the form is closed. I would like to prevent the...

I have a main form which has a combo box which the user selects a value. Then I have 3 buttons, depending which button the user clicks it takes them to another form that would be filtered by the selection of the combo box. I have a query set up with the criteria as [Forms]![Form1]![cbo3]...

I am trying to use a combo box and then a command button to open another form that would be filtered by the combo box on the first form. My command button macro reads where condition [Forms]![Form1]![Combo3]=[Query1]![Code] but when I click the command button I get a popup that says Enter...

I would like to copy and paste a large number of criteria in access. Is there a way to paste the criteria in without entering each one? Thanks

I am querying an access table from excel using microsoft query. I have selected the option under records allow editing. While in microsoft query I can edit the source data but when I return the query to excel I lose that functionality. Is it possible to run a query on an outside source return...

Is there a data type that I can use that will handle both text and numbers such as percentages? Or is there a way I can set the field type to text then convert the text to a percentage? I plan on using this field in a form so when the user inputs the info I will want to display it in the...

On a from I am creating I want to make it user friendly. They enter an amount for a percentage. I have the format set to percentage. If you type in 99 you get 9900% instead of 99%. Is there an easy way to correct this? Thanks