Advanced Query

[Exwarrior187]

Greetings all. I'm struggling with a Query and I'm seeking knowledge.



I have a DB all nice and set up and working the way it needs to. Now were looking to extract information from my nice DB. The problem is I'm looking for information in a "Notes / Comments" field, the data type is 'Memo'. Ultimately what I'm looking for would be something to the affect of:

A Query for:

[Prompt for a Date] + "a string of text".

Thanks in advance.

[TheShabz]

WHERE fieldname = [Please insert date (mm/dd/yyy)] & " your text here"

[weekend00]

I wrote a wong post and deleted it.

[Exwarrior187]

WHERE fieldname = [Please insert date (mm/dd/yyy)] & " your text here"

Thank you for the reply. Not sure if it's my syntax or something but it doesn't seem to work. Here's what I wrote:

SELECT *
FROM [Table Name]
WHERE ((([Table Name].[Field Name]) = [Please insert date (mm/dd/yyyy)] & "*my text here*"));

Any ideas. The Date + String that I'm looking could be part of a larger string altogether since this field is basically for notes. So there could be Text before and after it. Any ideas?

[weekend00]

what do you prompt a date for?

I think you are going to search for a text in the memo field, right?
SELECT *
FROM [Table Name]
WHERE [Table Name].[Field Name] like "*" & [Text to search] & "*";

[Exwarrior187]

I got it working now, thanks all. Here is my solution which is derived of all the posts here:

SELECT *
FROM [TABLE NAME]
WHERE [TABLE NAME].[FIELD NAME] like "*" & [Please Insert Date (mm/dd/yyyy)] & "*MY TEXT HERE*";

Thanks again all!

[weekend00]

how about "my text here" is in front of the inserted date?