Recent content by GATJA

I fixed the doubles at one point in time, but when I renamed all my queries that feed into this one, I gained doubles again. I don't know how, anyone? Here is my SQL: SELECT [Promo Booked BMS].PromoNo, [Promo Booked BMS].[From BMS], Sum([Promo Executed DMS].[From DMS]) AS [SumOfFrom DMS]...

Yes, another of my query troubles. I am running a query that is showing the number of demos booked, number of demos executed, then the percentage of demos executed. I have 2 demos that have 1 or 2 booked, but they have not been executed. They should show up in the query so I can get a percentage...

Heh, I just got that right before I checked back on here. See, I told you it was a stupid question, ha.

I am not sure how this query I made is pulling up wrong data. Everything else is fine, except for 1 row of data. It is supposed to pull how many demonstations were scheduled for that day and how many were executed. It comes up with 4 demos and 8 executed. That can't be right. I checked it with...

Hmmm, that didn't seem to work. This may be a really stupid question, but what is PCPN and PEPN? I may have forgotten it or just never learned anything about it.

I have another problem with a query I am doing today. When I run the query it brings up everything I need, but 5 of the Promo#'s are the same, but they have different # of Executed in them. They should not be like this, they should be together in 1 Promo#, not broken into 2. Here is my SQL code...

You are right, it did not error and it looks like it worked! Thanks for the help guys! I just had my boss over here and even he couldn't figure it out. We tried to do it another way, but that still didn't work. Everything looks good so far. I'll have to double check everything with other data...

I populated the fields with mock data PromoNo = 1 thru 10, # of Demos each have 10, PromoNo 1 and 5 were O, the rest E. Then I ran the query and it gave the same data type mismatch error.

I am trying to get the count of E's so I can divide the number of demos by the count of E's to get the percentage of executed demos. You have probably already figured this out by now though, heh.

Promo Count is a Query --------------- PromoNo # of Demos DemoOrder is a table -------------- Status PromoNo (linked by this) (plus many other fields I am not using) Is this what you meant?

Selena - I tried the 2 Status fields and it still gives me the data type mismatch error. Gromit - Which part of the SQL statement? I changed the bold part to just DemoOrder.Status = "E", but it didn't like that at all. I have no clue what I am doing really, so try to stay with me. SELECT...

Its ok, thanks for you help.

I already tried a new query. It won't even give me a count with just Status and criteria set to E.

No, I cannot do that due to company policy.

Here is my SQL view, if that helps. SELECT [Promo count].PromoNo, [Promo count].[# of Demos], Count(DemoOrder.Status) AS CountOfStatus, [DemoOrder]![Status]/[Promo count]![# of Demos] AS Percentage FROM [Promo count] INNER JOIN DemoOrder ON [Promo count].PromoNo = DemoOrder.PromoNo GROUP BY...