Search results

Hi, I'm making an Access database to help me register my fuel consumption, but I'm having problems to built the function. I have the following data, that I will register every time I go to the fuel station: Liters I'm putting in the tank Current Km Amount of Km I could run considering the...

Thank you. You are very helpful!

YES! But organized by MM DD

That was an example. The real code have brackets on names with spaces. Here is the full code, with your solution. The way I suggested does not work. SELECT Clientes.[Segurado] AS Aniversariante, Clientes.[Data de Nascimento], Format([Clientes].[Telefone 1],"(00) 0000-0000") as [Telefone 1]...

Here is the important part of the code: SELECT Clients AS Birthday, Birthday Date, Format(Phone,"(00) 0000-0000") as [Phone 1] As you can see, for the field Phone I manage to put the format directly where I select it. So the query get the phone number and directly input the format I asked for...

Ok now it works. But why I need a new column to do this? Seems so simple. I use format for the phone number and works perfectly. Why for birthday I need a new column, I cant put directly the format? Well its fine! I just hide the column and be happy forever. Thank you!

If I do this it asks for a number when I try to view the query and then instead of date appear codes (what seems to me random numbers)

Hi, I have a union query with date in the format ddmmyyy. This query was created to show birthdays of the month, which works but the order of the birthdays are all wrong, because in order to organize from oldest to newest, access is considering the year, not only day and month. How can I make...

I don't understand what you mean. But it's ok. I realized that I will need to normalize my data. The structure is wrong.

Hi, I have the following fields: Name (text) Date of Payment 1 (date) Paid 1? (yes/no) Date of Payment 2 (date) Paid 2? (yes/no) Date of Payment 3 (date) Paid 3? (yes/no) Date of Payment 4 (date) Paid 4? (yes/no) I want to create a query that will show me the names with "Date of...

For future reference, maybe the rules of the forum should change. I can't post URLs or Images because I don't have 10 posts. So, it makes hard to explain my problem. Hope you guys can understand the link I tried to show.

Seems that my problem is exactly this one: access programmers co uk/forums/showthread.php?t=197754[/url] And the solution is to bound the fields. [...]the form with the unbound controls filled in will be blank.[...] How can I bound fields? Where is this? Sorry, but I don't know what it means...

I'm trying to create a button that will open a form in a specific record, but it doesn't work See the screenshots with the steps I made: 1. Selecting the action of the button img148.imageshack.us/img148/9770/1openform.jpg 2. Choosing the option to open in a specific record...