Need Help with Retrieving Records based on user input

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

Guest

Hi
- how can you retrieve certain records based on what user enter in a pop-up text box. i can get records by askng for month by using this line in criteria field

Format([What month and year would You like?],"mmm yyyy")

i needed to know how to retrieve it by name, or first few letters of name, and other non numeric searches. i tried looking for it in the HELP menu but i couldn't find it. any help is appreciated.
 
Hi,




DateSerial( {What year you like? } , [ What month you like? ], 1)


would return a day, the first of the supplied month and supplied year.


Hoping it may help,
Vanderghast, Access MVP


Access User said:
Hi
- how can you retrieve certain records based on what user enter in a
Click to expand...
pop-up text box. i can get records by askng for month by using this line in
criteria field
Format([What month and year would You like?],"mmm yyyy")

i needed to know how to retrieve it by name, or first few letters of name,
Click to expand...
and other non numeric searches. i tried looking for it in the HELP menu but
i couldn't find it. any help is appreciated.
 
Back
Top