Search results

I discovered my error!!! Thanks for all your help!!!

I have tried all 3 expressions. It is giving me an error, "Syntax error (comma) in a query expression". Please help

it is really unnecessary for them to say "won or Lost" I would just like to combine active and closed into a single criteria. I am creating a bar chart to show the jobs awarded (active, closed) vs jobs not awarded(have Pricing). is that a little clearer???

I have a field which has 3 criteria: Active, Closed, Have Pricing. I want to combine the active and closed into one criteria called "Won" and the Have pricing will be called "Lost". Is this possible???

I have a field that I am using code to find a duplicate on BeforeUpdate. That part of the code works fine, however, I would like for the field to either sav a null or zero value in and not allow the AfterUpdate on the same field to work. Here is the code I am using below: If DCount("[Job...

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...

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.

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]...

Big duh...omn my part...I guess ive been too busy that i havent thought it out clearly! once again, Thanks for being my "thinking straight" brain!!! lol

New Problem, Works great in the query, but not in the report. The query is set up to only sort by the sort field created with the numbers for priority. What do you need to answer this question?

That was all i needed, i knew i was putting it in the wrong section. Thanks a bunch

iif(Priority='H', 0, iif(Priority='M', 1, 2)) I put this in the Criteria: section of the query.

I amtrying to sort a query and a report to "high, medium, and low" I have looked at several threads on this forum to answer that question, But i guess i am still so new, i cant quite figure out how to do this. I have created a column for 'Priority", and "priority by number" to facilitate this...

Paul, That did it, Thank you so much for all your help. As you can tell, I am very new at this! I really appreciate it !

It is now returning a zero

=DCount("[Bid Number]","FFP/T&M","[Bid Number]=") The other formulas are working great! this is the only one.

That is now returning an error. I have enclosed an attachment on how the report looks, I hope that helps

I Have a new problem with a different field. I am trying to count the number of bids that do not have a bid number. Here id the syntax i have been using: =DCount("[Bid Number]","FFP/T&M","[Bid Number] is null") it is returnig a zero count. Bid number is a text field. Please help!

I am trying to sum the amount of Jobs started that are quoted vs the jobs that are not quoted. I am using the following code: =DSum("

Never mind Greg, I figured out my problem.!!! thanks again