Search results

I'm have a numbers of tables that contain the number of quotes and sales by date. The tables are split by product So for example: table a/Table b/Table c all contain... Date/Quotes/Sales 20.02.07/50/20 21.02.07/55/15 I am trying to create a new table joining these 3 tables together by date...

I'm very new to Update query & need some help. I have a table with policy numbers (polno) which are in the format of "ABC 123456789" How do I create an update query to remove the ABC at the front of the policy number I tried this but it didnt work UPDATE [Renewal MI] SET [Renewal MI].polno =...

Hello All, I have one table that shows commission payments and policy numbers ie Table 1 fields Inception Date Policy Number Commission Paid I have a second table that shows every tranaction that has been processed on our system. ie Table 2 fields Transacted Date Policy Number Premium Source...

Hi! I'm having a problem with a query where I'm trying to show records from table (tbl Invites) and count the records from another table (Renewal MI) with a number of criteria and these are then sorted by the Inception date. It all works fine when there is data to calculate, but.... What I...

I have a table with Inception Dates (dd/mm/yyyy) and the number of policies sold on that date. I want to create a query that counts how many policies that have been sold. I know thats easy, but I'm not interested in the year part of the date. I just want to know how many were sold on that...

I have a problem with a Crosstab query in Access97. I'm trying to get a crosstab query to have set column headings (Inception Date,Q,C) as this query then feeds another query and its expecting these column headings. The status field in my table will be filled with either Q or C. It all works...