Search results

Hi, I am creating a excel calendar to record and monitor holidays and sickness I have sheet 1 with two calendars start and end date, I have a combo box filled with names to select and a button which you click to add the selected information to sheet 2, the problem i have is as the dates are...

Hi I have two reports that are generated from a button, once they are generated I then print both of them. What I need to do then is from the report printed and gererated I need to look up only a certain amount of data from that report and regenerate it and print it. Please could someone...

Thank you that is what i needed and thanks for explaining it.

Thank you for your information every one. I still cants seem to get this working given up on the query and parameters tring it in a form. Can you explain why it still is not working look at the attached db on post 13, as you can see this was made by a member of these fourms therefore I did not...

SELECT Table1.ID, Table1.Date, Table1.Days, [date]+[days] AS retest FROM Table1 WHERE (((Table1.Date) Between [first date] And [End date]));

so what do you think we should do to fix this? arent us and uk dates based on regioal setting on the PC?

Hi Bob, Thanks for replying. I have also done this and tried it in a form as I didnt know why it was not working either. When I try it in a form or even in the query now I find that it will only work if you put in a big date range. Even using your attached sample form it will not work. Try...

Hi Read this and it doesnt work? I have also tried like [find records beginning with:] &"*" Or Is Null. but this keeps coming up blank aswell? Any Ideas.

Here it is

there inst an SQL statement, is that where im going wrong. All I have is a date field which is manually inputted into e.g 01/01/08 A days field which will have e.g +7 And a calculated field based on the above e.g 08/01/08. Out of the above I want to filter out dates which are not within my...

I have a query which has a manually inputted date eg 01/01/08 to 01/03/08. In the query I want to filter out all the dates outside of that date range eg 01/04/08 should not be displayed. I only need 01/01/08 to 01/03/08 displayed within the same query. I am trying to do this by using parameter...

Sorry for not explaining my query correctly I cant see where im going worng

Hi Bob, inst a search facility based on a forms text box?. The result I need is only in a query based on what is already in the query? I just want to filter out results in the query based on the parameters inputed

what post is that then please

Hi I have a query that has date field, days field and a calculated field based on the days field. E.g Date: 01/01/08 Days +7 (this can change) Calculated: 08/01/08. I need to be able to put in a parameter for the start date (01/01/08 and end date (20/01/08). This should only show the...

Cheers Bob. It work. Thanks Again for your help

Thanks I have the query to now show the next test field automatically. Cheers. I was not removing the old field next test after creating the new one. Now I have inserted in the new field I have made the following Between [Forms]![nexttestreport]![txtStartDate] And...

I have tried that and it is not working. I cant seem to make the next test field appear automatically in the query.

I think I have got to the bottom of it. How can I make a field in a query = a form field

sorry, ok the field which is not working is called next test. I think this is because it is a calulated field and it is always blank in the table which is queried ie calculated in the form and not the table, however the last test is not blank in the table and therefore it will display the...