Search results

I have a field in a form that contains the years that households have participated in my neighborhood garage sale (I'm a Realtor). So, that field contains for instance, 98,99,00 and now I want to append to the end of that field the year 01, through an update query, to several hundred records. I...

Okay, I think I have discovered the answer. I think Rich had it right. Once you are in your QBE Grid you have to then right click in the upper protion of the screen and get yourself a "Select Query", then you drop in the fields you want to total. THEN you hit the Sigma Icon, Change the Group by...

Thank you ejstefl for you explicit instuctions, but I still can't get it. I found the QBE grid, and the Sigma Icon and did EXACTLY what both you and Pat said to do, but I when I run the query, (I assume that means hitting the little ! point at the top that says Run when you highlight it)I still...

Thanks. That worked great!

How do I get to the QBE grid (don't know what it is)? And what is the Sigma Icon, how do I recognize it? (Sorry, I have only been using access for a couple weeks, pretty much 24/7 though.)

I have created a query for home sales. The commission field is a calculation and it shows on my form, but not in my query, also I checked my Dataview and it doesn't show their either. Is this normal? How can I make it show up on my query.

Thanks Rich. So it sounds like you can not total up a row of numbers in an initial Query. You have to make a second query based on the first. If that is the case then you might as well just total it up in a Report. The reason I want to find the total in the first query is so I don't have to take...

I have searched the archives and can find answers to much more complicated questions than mine, but not my question. Mine, I think, is embarrassingly easy to solve - - I am trying to make a query that will total up the total value of a list of homes that have sold. So, like, there are ten homes...

Is there anyway to group reports other than the automatic alphabetical order they are are put in? I have lots of report and would like to keep them in a particular order that is most easy to use. Thanks.

Thanks for the info Pat. Turns out what my problem was, is that I kept trying to affect how the date looked in my report by making adjustments in Table View formatting of the Record source I was using for the Report. Well, of course, the changes I made to formating in table view only affected my...

As an example. Dates look like this 2 / 6/02 and 12/14/02, so they don't line up and look crummy on a report.

Rich. Thanks. They are fomatted as Date/Currency and then they were formatted with an input mask of a "short date" with # as the place holder. It says that the # leaves a blank space where there is no digit. __/__/__. And that's exactly what it does. I have since removed the input mask, but as I...

I have a minute problem that is a huge headache. I have tried for hours and can't fix it. I designed a report that has a "date field" in it. The dates with one digit in the day or month, don't line up with the dates with 2 digits in the day or month. This is because their is a blank space in...

Thanks Pat. So am I safe using the compacted copy to my zip disc in case my computer were to crash? It seems to work just fine when I copy it from my office computer to my home computer, and it copies so much faster that the backup copy which as I said is 57MB compared to the compacted copy...

I just started using Access about a week ago. My file that had been 57MB, has now become my backup file, and another file was created with the same name as my original file but it is only about 7MB. I didn't do this, the program did it all by itself. I copy to a zip to keep another computer at...

I think I've got this right now. Posting a reply, instead of a new topic. Keith I found the answer I was looking for at: http://2fix.bvu.edu/help/apps/access/EA3W846OO.ASP - It was what you were talking about Keith but it told me (a rookie) step by step how to do it. I am stoked! It was easy...

Steve, I tried that and it didn't work. Nothing happens when I hit CTRL End, CTRL HOME OR END.It almost seems like the keys have been disabled or something. When I have my cursor in a field and hit end it does go to the end of the field, and home does go to the beginning of the field. Any...

Thank you Steve.

Is there a keystoke to jump to the beginning or end of a long from?

Yes, Keith, Rich actually responded to me a second time, and he pointed me to another site. I went there got the info and changed the code. It disabled my page up page down keys, but also my tab key and alt key which I don't want. I just want to either disable my page up and page down keys, or...