Search results

Ok my goal is to have a calculation in a query that includes a bunch of addition, division, and multiplication. (It uses 10 pieces of data) I tryed typing it in the expression builder but it doesn't work. I don't know if I am setting it up wrong or putting it in the wrong spot or what. I've...

thanks for the file

I'm sorry but I don't quite understand what you mean. I based the report off of my table, not a query, if that has anything to do with it.

ok I set up my report but how do I limit it to the one being seen. The way I am printing them now is just putting the id number in the print from page to page. Is there a better way. Also is there any way I can do a search to find a report among a bunch of them through the report page...

I got it, thanks. I was mismatching my data so it didn't seem like it was changing. I retested it and it works :) Sorry this is my first time using access and I am really bad at it

I would really like to leave the field in the yes/no or true/false form so when I go into the table or any form I can easily check off the box. I don't want to have to right yes and no every time. thanks

I would like to run a query and then be able to edit that information. I want the data I change to be put into the table the info was gathered from. Right now when I edit the query data it only saves it there, not on the other table. I tried to do the copy to table but the original table was...

In my chart I have a yes/no field that I would like to set up a query to for. I want the user to be able to input yes or no and then the data be displayed. Whenever I enter yes or no when the prompt comes up, I get an error saying the expression is typed incorrectly or the data is too complex...

thanks...that works well in the find and replace. Is there any way I could do that for a query, though, so I can have all the data be pulled out of the huge table and seen only with the pieces of data I need. Thanks

Is there any way I can do a search that lets me put in a section of a part number and the part number be found? I only see how I can find the number if I put in the entire number. Thanks

:eek: When I go to print the form, it repeats the detail section over and over. Instead of being one page, it is 1414. How can I fix this problem? Thanks

sorry but where do I find the forums on "Cascading Comboboxes". I am having trouble locating them. Also is there anyway you could tell me how to at least put one query into a form. That will be enough to get me started. Thanks

I would like to put a query into a form so that I can look up a part number, order number, or both, and then open the form for editing. I set up the queries but can't get them into the form. How would I go about doing this? Thanks for helping.

I would like to put a query into my form so that I can look up a part number, order number, or both, and then open the form for editing. I set up the queries but can't get them into the form. How would I go about doing this? Thanks for helping out

I would like to put a query or some look up device into my form so that a certain part number can be found and its form opened for changes. How should I do this?

I based my form off of a table but I want the info that I put into the form to go into that table I based it off of. That way I can edit and add data in either the form or table. Also if I base it off a blank table I can put data in. When I base it off of a table where I already have a lot...

I have been working on this for hours and I can't seem to find how to take the data I input into a form and have it appear in another table I had created earlier. I want to be able to pull the data up from either source and then edit it. I can put the chart into database mode but that isn't...