Recent content by trkl

should i include balance to design grid 2 times.isnt it gonna violate any database design principles.

the problem is how to find the maximum and minimum balances in the above database. if we include balance field as a single field in design grid of query and hit the totals button.it would show maximum if we select maximum in the dropdown arrow of Totals Row in design grid.and would show minimum...

http://www.4shared.com/file/LlakuQbS/Senior_Care.html

Glaxiom your suggestion solved the problem. Thanks

CazB a similar problem comes.for example in the following Table whish is Items Table. Item Number Description Price Quantity Date Posted Condition Seller Code 1663 Metal Chairs $5.00 4 3/1/2012 Excellent ER 1683 Patio Set $60.00 1 2/26/2012 Excellent SE 2563 Loveseat $45.00 1 2/25/2012 Good SE...

If By TOP you mean Maximum value and the second last maximum Value then thanks my answer is complete.Thanks.

for example in a set of numbers {1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20} the maximum value is 20 and the next maximum value is 19.

Thanks.but there are ways to do it in MS Access 2010.i dont understand it because i dont know VBA and other Database Languages Yet.so plz tell me how to do it without any coding.Also Glaxom it would include all the Records.and by using other options,i can get top 5,top 25,Top 25%,100,All Records...

Right click on a field then select properties and then in duplicate values there are ooptios of Yes and No.select no.and close property sheet by clicking close button.now you wont see duplicates in a field.

to display the maximum value in a field.you would press Totals button in query design Grid.its button on toolbar.when you press it it has group by option besides others in the design grid.Press the Drop down button in Totals row in design grid and select Max and it would display the Maximum...

above link is in compressed form

the 1st relationship was created ok but the 2nd wasnt possible.. http://www.4shared.com/archive/Y5xJHsKW/GEM.html" target="_blank">http://www.4shared.com/photo/sZVexLmE/GEM.html ms access 2010 doesnt create relationship b/w following tables plz click below to see tables,their relationships and...

in below database http://www.4shared.com/file/XbC2kv5A/Supplier.html in the product table,most of the records were added by importing Excell 2010 workbook whose link is below http://www.4shared.com/file/Yz3MEF1_/Goods.html when trying to enforce referential integrity between above two...

calculated field works in ms Access 2010 but not in mS Access 2007.if you have ms access 2007 then its not gonna work but if you have ms access 2010 then its work.

if you do that in Ms Access 2010 then its very easy there.