Search results

Hi, I have 2 related. In the first table I have a primary key number and another ID number. On the 2nd table which is related by the PrimKey I want the ID number to come up automatically. I can't remember how to do this. Can anyone help? thanks

Hi, I've created a button through the wizard but when I click it, this comes up: "compile error" Option Compare Database SELECT FROM Query([Litters per year]) WHERE Month = [date?] i've tried deleting both the code and the button,but the complie error just comes back.

How do I make a botton on a form open a report when pressed? thanks

In my database I have a Month([Date]) field which returns records from the criteria of month "1", "2" through to "12". However I want it to return them for those months only of this year. Is there a date function where I can have something like Month([Date]), Year ([=Now]) thanks

In my database I has a Month([Date]) field which returns records from the criteria of month "1", "2" through to "12". However I want it to return them for those months only of this year. Is there a date function where I can have something like Month([Date]), Year ([=Now]) thanks

Hi, I would like to have a report linked to a query. I want the query made with a date field. When the report is opened I want to be asked a month and it shows me all the dates data within that month. Could anyone help me with this please. I also want the data to be from the current year when...

Hi, I want to create a query that i can select a month from a list and display all data in my table from dates within this month. I have not had much luck doing this so far so any help would be much appreciated. Ultimately I would like to have a report that when I open, ask me to select a date...