Query #error

engelwood

Active Member
Joined
Oct 14, 2004
Messages
327
All,

I have a query that is returning #error instead of a null value for a calculated date field. I'm using the dateserial() function to transform the individual dates to the first date of the month. (e.g. dateserial(year([posting date]), month([posting date]),1)) In another query I'm using that field to join and return a value, which returns as #error. I've tried nz(), isnull(), and isempty() for the error handling, but I still get #error. I also tried the cdate() function to ensure the field is recognized as a date, but I still get #error. Any thoughts of what I could do differently to remove the #error?
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
don't use dateserial (excel),
in Access use: month([dateFld]) & "/1/" & year([dateFld])
 
Upvote 0

Forum statistics

Threads
1,212,933
Messages
6,110,752
Members
448,295
Latest member
Uzair Tahir Khan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top