Criteria to check for existing set of records

[Khalil Handal]

Hi to all,I have a Database with a query linked to an Excel wroksheet. The worksheet shows monthly payments. The values are different each month.When I open the database, the query shows the values of that specific month. I was able to add the values from the query to a table; this table is used as a history table for all months. One of the fields is the month name and is shown as MMM YYYY (example: Feb 2025 Type in the Excel sheet).I want to be able to check for the month before adding records to the history table named tblHistoryPayments. Example: If (Feb 2025 ) exists then a message box will appear saying that payment for this month is already added to the table. I have a command button to add the records to the table tblhistoryPayments.How can I do this and add the criteria?Sincerely,Khalil

[Welshgasman]

Use DCount()

[Khalil Handal]

Hi,

I tried the following:

CountRec = DCount("[pkHistoryPayroll]", "tblHistory", "[F17]=" & Me.txtLastMonth)

F17 is the field containing the value of months.
but have the error:

3075 runtime error missing operator in query expression '[F17]=Mar 2025'

any ideas?

Khalil

[ArviLaanemets]

The value of Me.txtLastMonth is a string, so probably something like

CountRec = DCount("[pkHistoryPayroll]", "tblHistory", "[F17]='" & Me.txtLastMonth & "'")

I myself prefer to use month numbers like 202503 (a numeric value). In case you need for some reason the text value, like you used, simply add a months table like tblMonths: MonthNo, MonthTxt, and read the matching text from there. Or tblMonths: MonthNo, TxtType, MonthTxt - which allows to have text values of months defined for various text types like formats, or languages, or whatever.

[Khalil Handal]

Hi,
Thank you very much
Khalil