Search results

How do I do that exactly?

In my database I have 4 different forms that relate to the same pieces of casework. They are 'Person Information', 'Incidents', 'Actions' and 'Outcomes'. The Primary and Foreign keys are set up as follows: Person Information - IPSOref (PK) Incidents - IncidentID (PK), IPSOref (FK) Actions -...

Is there something you can use to automatically generate the last calendar month as well?

Thanks! I appear to be set up and working!

Exactly what you wrote above ie: Between "#" & [Enter Start Date] & "# And #" & [Enter End Date] & "#"

Thanks but when I did it I got the following error message: 'You did not enter the keyword And in the Between...And operator The correct syntax is as follows: expression [Not] Between value1 And value2' So what to do?

Thanks Bob. I forgot to mention that I'm stupid though. Do I copy and paste this into the criteria section of the query? The statement currently in the criteria part that isn't working is '>=[enter startdate] And <=[enter end date]'

Sorry to resurrect this old thread... This date issue is the only thing that isn't working now. The rest of the database is fine and dandy. On the records that I want to pull out, the dates have to be entered as mm/dd/yy and then Access reformats them to display the dates as dd/mm/yyyy and...

Yes, thanks

:) Clear enough. The code is as I quoted in the previous post as in the criteria part of the query. It doesn´t seem to regard the dates at all. It just pulls out all the records.

Thanks for the help on this. I´ve realised why the records weren´t showing. Basically because I had linked tables and they wouldn´t display the ones with null values. However I have another problem...I´ve entered the code as above and it doesn´t seem to have any effect on the dates of the...

It only pulls out some of the records. Going by the month of Feb, we had 113 cases. When I searched by date, it only pulled out 89 of them.

and if so, how will this affect the data already in there?

Yes it is. Do I have to change it to a text field?

Anyone? Can anyone tell me why it won´t display certain fields that I know fall within the date range?

the dates in the colum refer to date of contact.

Ok, I´ve checked the SQL and it is using ´date of contact´for this criteria. why is it not displaying records that have this field completed and fall between these dates?!?!

Great. That seems to work, except...does it calculate the dates on when the records were entered into the database? I´m trying to link these dates to a field called ´Date of contact´so we can sort them by this.

Thank you. Let´s try...

Thank you. So where exactly do I copy and paste what you´ve written into the query sheet in design view?