Search results

Hello, I am not sure if I understand what you would like to do. I think that you are trying to filter records and then update the information in 2 tables. If this is what you are doing the you could make a new form for this. On the form that you have now place a button and use the code builder...

You could put 'DateSerial(Right([Date],4),ConvertMonth(Mid([Date],4,3)),Left([Date],2))' into the 'Field:' row of a select query and this will display the date. You may then use an actual date in the 'Cirteria:" row to display the results you need. Hope this helps. Art

These are the questions I have: Have I made the db too detailed to provide such a simple report? NO Rather than have the entire date in one field, do I need to have 3 different fields - one for month, one for date & one for year? Have one field with the date only. In a query...

I am not sure what you are doing but this should get you close. SELECT Personeels_evaluaties.Itemnummer, Personeels_evaluaties.Personeelsnummer, Count(Personeels_evaluaties.Itemnummer)as [Count] FROM (Item_stam INNER JOIN Personeels_evaluaties ON Item_stam.Itemnummer =...

Just run an update query for the 2 fields. Run it in the same macro. Hope this helps.

Hello, This is my first time doing this. There are a lot of ways to do this. You could open the table in design view and change the data type to date/time. Or if you wanted to learn something more you could copy and paste this simple function into a module and then setup a query like this...