Search results

have ms access table where values are stored as monthly. .. one record per month with date as 1st of the month example: Customer Date(dd/mm/yyyy) qty 1 01/01/2010 100 1 01/02/2010 80 1 01/03/2010 90 ...now i want to split this info into weekly and store into another table...and if a week...

can u give example i cant get it...can u give the query sql statement

error in your solution when i try to write a similar query i got error "You tried to execute a query that does not include the specified expression <name> as part of an aggregate function. (Error 3122)" my query is: SELECT barcode.itemno...

sub report Hi melanemac so you have created the sub report. Dont you want to share you knowledge with me on how to create a sub-report, because i dont know it. my requirement is simple. in main report i need the sum of all invoices and in sub-report i need list of invoice numbers.

i have a table A with columns ( A_ID, Main_Quantity, Sub_Quantity) and another table B with columns (B_ID, B_Name, B_ConversionRate) now i want a query, so that the result i get is as follow A_ID, sum(Main_quantity) + sum(Sub_quantity) / B_ConversionRate, sum(Sub_Quantity) - sum(Sub_Quantity)...

i have developed an access database application with forms... now i want it to distribute to my users........how should i make exe file..or what is the method of installing the applicaiton on client's computer...

i have a textfield on the form, its associated with a field in the table. a barcode scanner will directly enter complete barcode into the form field. now i have to provide validation so that duplicate values are not stored. my barcode is as follows 060010305001 ( here 06 is supplier number...