Search results

Hi, I have a field called Quarter_Key. If the values in this field are like 200601, 200602, 200603, 200604, 200701, 200702, 200703, 200704 and so on.... Then I want to insert a new fields based on the values. For instance, if the values that are found in the Quarter_Key are 200601, 200602...

Scooterbug, there is no query at all in the file you attached.

I have a attached a sample database in my previous post. Pls. feel free to do anything as long as i get the desired results then i don't mind. thanks so much for your time.

Thanks for your quick response. But what i am trying to achieve is different. Here is what i want to do in a simple way: I want all the value in 200701 from the Main Table to be devided 2007Q1 in the Secondary table and the same thing goes on, I want all the value in 200702 from the Main...

Hi, I have 2 tables, one is called Main table and the other one is called secondary table. Both tables have the following fields: 200701, 200702, 200703, 200704, 200801, 200802, 200803, 200804, 200901, 200902, 200903, 200904 and so on&. Both tables have always equal fields meaning if the Main...

Hi, I have 3 fields in my table and would like to format them into currency, percentage and dates. Is there a way to do this using vba? Field Names are as following: Cost, Percentage and Date of Purchase Table name is MyTable. thanks for your help

thank you so much boblarson, it is working now. Many thanks for your help

Thanks for your time. I actually don't need a report i would it to have in either query or using sql. I have a huge data and i need this to incorporate that data. I have researched and found out that it could only be done in sub query and i don't know how to do that.

Thanks for the quick response, but this is not what i was looking for. I want to be able to count DISTINCT contracts. The query you have attached counts only number of contracts and i am looking for a DISTINCT contracts. I was researching for the last 2 days and i think it should be done in...

Hi, I have the following fields: Zone Product Segment Contracts So, i want to count a distinct contracts per Product Segment for each Zone. In other words, i want to count distinct contracts and group them by Product Segments and by Zones. I have searched in the form and could not find any...