Query dates within the same week from 2 different columns

[cookitup]

I am trying to populate a query that uses the dates within the current week from 2 different coulmns. The code I am using is below:
DatePart("ww", [Date Bid Sent]) = DatePart("ww", Date()) and Year([Date Bid Sent]) = Year(Date())
I want to also query, on the same query, Jobs started [Start Date] during the same week. I have tried several different things to no avail.

 

[cookitup]

Did i not give enough information to accurately describe what I am needing? I am new on the forum, and may need a little coaching. Just let me know what you need.

 

[spikepl]

Yes. What is "no avail"? Do not ever write "to no avail" or "it did not work" , because it only says that you are unhappy, but doesn't contain any other info.

Always say what you want, what you did (code/SQL), what you expect, what you got, and any error messages or other reactions from the system.

"I am trying to do X,Y,Z but fail", does not give any specifics either. "I am trying to make a million but failed - please help" .

In this instance -what is the actual problem? What did you do exactly (show code/SQL), what did you expect and what did you get?

 

[cookitup]

AMEN! you are right!!!
Let me try this again.
I amtrying to query from 2 seperate columns on the same query. I am trying to query 1 column to find dates within the current week based on "Date Bid Sent". That coulumn is working perfectly. This is the code I am using in the criteria section of the query in the "Date Bid Sent" column:
DatePart("ww", [Date Bid Sent]) = DatePart("ww", Date()) and Year( [Date Bid Sent]) = Year(Date())
I tried this code in the criteria section of the query under the 'Start Date" (this is the date the job started) and it returned a blank query. The code I used there was:
DatePart("ww", [Start Date]) = DatePart("ww", Date()) and Year( [Start Date]) = Year(Date())
I need to compile a query that will pull not only the quotes [Date Bid Sent] that went out in the current week, but also the job started [Start Date] within the current week and have it populate on the same query.
Trying to put these 2 codes on the same query only returns a blank query. Please Help. Thanks