Date by Month error on report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i am trying to get a report grouping by month and a pop up screen comes up
and states Format$ asking for input. No matter what I put in the box the
report shows $Error where I want the month to be.
 
Karen

I believe this is caused by a broken reference. I assume you are using the
Format$() function to derive a month from a field of data type 'Date/time'?
The reference to the library containing this function will probably be listed
as 'missing or broken' under 'Tools/References' (in the visual basic window,
which you can open from 'Tools/Macro/Visual Basic Editor' in your report
design window. Hopefully resetting the reference will fix.

alikwok
 
Back
Top