Recent content by JCRamirez

Because I need to be able to update the information. I want to use the query to use as a record source in a form. The form need to show all the slabs and I need to be able to edit the information or to add a new rates. So far the customer wants to use a similar form like the one it is shown in...

Majp, the proposal @arnelgp it is good. Now my issue is that I want to be able to modify the value. For this case I think to use the query from @arnelgp and create a new table and from there use it as a base of my record source

It is a good proposal, I think I can work on it. Thanks a lot

MajP thanks for your proposal, but the problem is that all the other slab that are not Min, -45 +45, +100, +300, +500, +1000 should be in the same column

You are right. This Database is old and I'm trying to improve it in many aspects, including the suggestions that you made

MajP, I though about a cross table but as my understanding will not work. See the sample file that I attach I'm sure will give you a clear picture of what I intent to do

Dear Arnelgp I check the cross tables and total queries but it is not convenient because I have the Pivot column. This range is not always the same. The value will change every time. For a better understanding of what is my request you can download a sample of my database

I have a table that shows the net cost and selling cost depending on the weight. The Slab of the rates are from Min, -45, +45, 100, 300, 500, 1000, Pivot I created 8 queries to filter a different Slab of the table for example the query of Min is as below RateAirlineSlabTable.RateAirlineid...

I have added in my report a child form that has some unbound textbox. The child form will use the dvlook function to fill the unbound textboxes and everything works perfectly fine. In the screen, the report shows the information and also the information is shown in the print preview, but when I...

Thanks for your suggestion, but I followed whtat London said and I could fix my problem

Thanks, I could solve my issue with your suggestion. I don't know why I couldn't figure out before

I'm new in this Forum so I hope I'm posting in the correct place. I'm working in a form but some how when I use the docmd for going to a record then the subroutine will start again. The interesting thing is that when I go to a new record the situation doesn't happen. The code that I'm having...

My name is Jose Ramirez and I'm from Mexico but I'm living in Japan. As a personal goal I decided to create a database in access because I know how powerful is it and can make my job more productive. I studied access when I was in highschool, but after that I never use it again.