vb arghhh i dont understand it!

[michellerobinso]

i have a search on my database adapted from the one attached.

i would like it to display the

month field
return number (ID)
year field

the month and the year are formated =Format(Month(Date()),"0")

but when i run the query and the search they are just blank, is that because it will only display in the form?

how can i get it to display this information?

many thanks

Michelle

 

[mhartman]

Hello Michelle
The function: =Format(Month(Date()),"0") evaluates to 7. What field are you placing this value under in your query? That field must have numbers in it for starters. If it does not, the query will return nothing as you state.
'
Regards
Mark