wrong search results

[Welshgasman]

I am not sure why not for me. this date fields are big trouble. i GOT IT. it accept only date format 22.12.2024.

So you did not see my picture?

[mike60smart]

You can use all of the following formats for the Date Search
22 12 24
22.12.24
22/12/24

We were glad to help

[guest]

i didn't know that. I tried first with format 22-12-2024 didn't work than I tried with 22.12.2024 which worked so I will do it that way.

[moke123]

Just curious if you tested with ambiguous dates like January 2 and February 1 (1/2/2024 and 2/1/2024)

[Welshgasman]

Just curious if you tested with ambiguous dates like January 2 and February 1 (1/2/2024 and 2/1/2024)

Seems to identify each.

[mike60smart]

Hi Moke

Just tested and the following works:-

01/02/2024
02/01/2024

The following does not work:-

1/2/2024
2/1/2024

[guest]

Hi Welshgasman,
I have another question about searching. Can i continue here or I must open new thread.

[June7]

A new thread might get attention from more readers but can ask here and those of us already giving this one attention will try to answer here.

If you work with non-U.S. date format, review http://allenbrowne.com/ser-36.html

[guest]

Hi June7
So this database we fixed is about year 2024. for 2025 i will make same database, same fields but populate it with new data. I also have more databases from previous years. what i do if don't find what i am looking for in 2024 i open 2023 and search there etc. Can searching be done from 2024 for all years and how to do that.

[June7]

Link to tables in other dbs.

It is possible to query data in another database without having to set links.

But why build a new file just because year changes? I have database with 20 years of data in one file.

[guest]

I have too. That's the rule. Each year must start with number one and end up with how many numbers there will be.

[June7]

Yes, my db does that. I have code that assigns a document number to each record in primary table. The number starts over each year. But still just one db and one set of tables. I can easily query for any date or range of dates. The autonumber key that Access creates is not relevant to this constructed identifier. I also assure there are no gaps in this document number, all numbers in series are accounted for.

Generating a custom unique identifier is a common topic.

[guest]

Ok. Than show me how to do that.

[June7]

Start with review of https://www.accessforums.net/showthread.php?t=23329

Another approach would be to generate this yearly sequence number dynamically in a report where textbox has a RunningSum property that can accomplish this. However, if records are sorted by different criteria then they would not show the same identifier in each sorted set.

[Welshgasman]

Hi June7
So this database we fixed is about year 2024. for 2025 i will make same database, same fields but populate it with new data. I also have more databases from previous years. what i do if don't find what i am looking for in 2024 i open 2023 and search there etc. Can searching be done from 2024 for all years and how to do that.

No need for another DB, you can get what year the data is for with the YEAR() function.