Replies

Hey John,
I figured it out. Thanks so much for the help. This is working perfectly.

Bret

Hey John,
I figured it out. Thanks so much for the help. This is working perfectly.

Bret

How do I add a new contact list? I have looked and can’t seem to find it. I think that is what I really want to be able to do.

thanks again,

Bret

How do I add a new contact list? I have looked and can’t seem to find it. I think that is what I really want to be able to do.

thanks again,

Bret

That returns only 17 points but it shows them all as 12:00:00 am.

That returns only 17 points but it shows them all as 12:00:00 am.

I guess I was a little hasty in my last response. I didn’t tell you about the report. For whatever reason the chart give totals by month. Here is a copy of the query.

SELECT ([DateTime]) AS Hr, Avg(Invoice_Totals.Total_Price) AS AvgOfTotal_Price
FROM Invoice_Totals
GROUP BY ([DateTime])
HAVING (((Avg(Invoice_Totals.Total_Price))>0));

It seems to give me what I expected, but when I use the chart wizard as I said it give me monthly totals.

Bret

I guess I was a little hasty in my last response. I didn’t tell you about the report. For whatever reason the chart give totals by month. Here is a copy of the query.

SELECT ([DateTime]) AS Hr, Avg(Invoice_Totals.Total_Price) AS AvgOfTotal_Price
FROM Invoice_Totals
GROUP BY ([DateTime])
HAVING (((Avg(Invoice_Totals.Total_Price))>0));

It seems to give me what I expected, but when I use the chart wizard as I said it give me monthly totals.

Bret

This works great Hans but, it returns 110,126 total points. How do I get it to combine the hours 9 am to 10 am, 11 am to 12 pm, etc.?

This is where I thought I might have to do this for each hour with something in the criteria field like, Between 9:00 am And 9:59:59 am.

Bret

This works great Hans but, it returns 110,126 total points. How do I get it to combine the hours 9 am to 10 am, 11 am to 12 pm, etc.?

This is where I thought I might have to do this for each hour with something in the criteria field like, Between 9:00 am And 9:59:59 am.

Bret

Ooops, you are right I would be looking at thousands of points of data. The average would be correct. I just want something that will visually demostrate business volume. I think it might help in our scheduling of staff.

I am totally unaware of how to create this calculated field. I would need to create one for each our that we do business wouldn’t I?

Bret

Ooops, you are right I would be looking at thousands of points of data. The average would be correct. I just want something that will visually demostrate business volume. I think it might help in our scheduling of staff.

I am totally unaware of how to create this calculated field. I would need to create one for each our that we do business wouldn’t I?

Bret

Okay, I’m Bald. I have combined all of 2002 into one table with the following fields, ID, Temp, Soft Serve, Food, Drinks, Cakes, Coupons, Customers, Date (long format). I will work on the rest of the tables over time to get them combined into one year.

I don’t know if it really matters where I start so if it doesn’t I would like to have a query that would convert 2002 dates into 2003 so that I know what my sales should be. As the example I gave before I would like to be able to have a form that says, June 3, 2002 was the first Wednesday in June therefore, June 4, 2003 should have sales of X (X=June 3rd 2002 sales).

Thanks for the helps folks.

Bret

Okay, I’ll combine them. And once I am bald I’ll check back with you.

Thanks Charlotte.

Thanks to every one the help you gave on this issue has solved the problem. As was suggested, the Regional settings were wrong. As of Saturday he was getting things straightened out.

This group is so great!

Bret