Search results

Thank for the tip Guus! But now I have two doubs! I have make Product and Product Type a combobox in Transaction table, which takes the information from products table and product types table. The problems are: 1. The combobox displays the ID's, not the text. 2. Once I choose a specific...

Hi! I have done a query which has calculated fields, but I can't edit the stored fields directly from the query, instead I have to go to the table so as to edit it. Is this the way it works or is something wrong? SELECT [INSTRUCCIONES DE EMBARQUE].N_OP, [INSTRUCCIONES DE EMBARQUE].[N° FAC...

Thank you a lot Paul!! Specially because of being so patient with me!! :D:D Now I could make it work withouy any problem! ;)

Thanks Paul! I don't wanna seem to be so silly but I don't get where do I have to put all that "code" you posted above. :confused:

Hi! I have one table called "TRANSACTION" with: [id transaction] [product] [product type] And I have a 1-many relationship: [id product] [product] [id product] [id product_type] [product_type] The doubt I have is how can I make the main table called TRANSACTION, once you choose a product...

Hey! Here I have attached a sample DB using the parameter, but it is not working okay. In the query, it doesn't filter. In the report, it just shows one persons name, but it shoes the items of the rest of the people.

Thank you Adams!! I actually noticed about the change of the date was affecting the date, not the weekday, that is what I was actually wanting to do. And also thanks Neil for the tip! I'll have it in mind

Thank you emma!! I actually thought about the second point tho not about the first one!!! :D

Thank you Gary and Brian for the answer!! I could finally understand how to use it!

Thanks Bob you tips and info really helped me!!! :D

Thanks a lot Adam! I have one doubt, is IIF with two "I" or it was just a mistake? And the other thing was just, if a date was sunday, then I wanted to move it to monday, like this: IF(weekday([DATE_OF_TRANSTACTION])=0;[DATE_OF_TRANSTACTION]+1;[DATE_OF_TRANSTACTION]) considering sunday=0...

Oh, this time I didn't use criteria! I just created a parameter in the Query. Example of query: [TRANSACTION N°] | [PRODUCT] | [PRICE] ----------------------------------------- 1 | GARLIC 1 | 5 1 | GARLIC 2 | 5 2 | GARLIC 1 | 6 3 | GARLIC 3 | 2 Then I add as parameter "TRANSACTION N°" Each...

Thank you bob!! So if I understood okay, I should have a table for each "constant" like this: [ID COUNTRY] | [COUNTRY] --------------+------------- 1 | ... 2 | ... 3 | ... Although I'm not really sure why should I use an ID and not just the country name, since registries wont repeat if i use...

Hi! I would like to know if MS Access can handle functions that Excel has, for example, "weekday" function, that returns a number representing the day of the week (sunday=0, monday=1, ...), given a date value. If so, I have a conditional like this in excel...

Hi! I have a main table that has many fields like "Country", "Product", etc... which they tend to repeat. I thought of creating one table for CONSTANTS values, like this: COUNTRY | PRODUCT | .... USA | ORANGE | ... MEX | LEMON | ... ... | ... | ... The fact is that actually USA and Orange is...

I'm not sure how this should work. I added a parameter using a column's name. When I enter the query it asks for the parameter value but it doesn't filter the query. Nevertheless, when I create a report using that query, it asks as well for the parameter but this time, it does filter!! Is...

Thank you Paul!! I could make it work using the criteria thingy!!

Thank you pbaldy! Excuse my ignorance, im a bit newbie to Access, where can I add these criteria or wherecondition arguments? If someone can tell me in some steps it would be really nice! :D

Hi! I would like to know if it can be made a report (or query) of only one entry, or if it exists a way to filter the report so as to show only one "ID" and all the sub-items it has. Thank you!

Thanks for the advice Brianwarnock! I will think about it! Althought I still would like to know how to store a calculated field in a table. In case no one of you know how to make it, how can I make a calculated field in a report? I just can make reports using the report maker... :(