query math

[knice11]

Can someone please help me understand how to get a query to math calculations? Ive read several post and it seems that people have queries do the math for them but never say how or what steps they take to get that. Access is not my friend as of right now. The query would need to do this on a daily basis.

Thanks in advance

 

[bob fitz]

Hi

Can you give us a bit more detail about the required math calculations?

 

[knice11]

it is supposed to show the number of units by warehouse and season description. The warehouse is on one sheet in excel. The season description is another sheet in excel. I have to create a query that can be opened showing the above. How can i do this? I dont think there is a required calculation to be shown as long as it shows # of units by warehouse and season descr. If I need to, I can send you an example of the data.

 

[bob fitz]

Hi

If I need to, I can send you an example of the data.

Yes please, that may help.

 

[knice11]

Here is the sample data. I attached it. Let me know if this is clear and if you can please get me going in the ight direction.