Recent content by HMC

I'm a bit worried about losing data by doing an append. Barry's suggestion might fit. If Barry, you could tell me when you say, "so you could add a yes/no field to your main table, which table would you suggest or can it be done on a main property form I have which shows mosts of the tables...

thanks to all for your replies. Pause for thought. The records I want to delete or rather before that place in another table 'sold' for history/archive purposes, are already linked relationship with other tables. This is causing confusion and difficulties. The yes/no box looks like a good...

rainmain, thanks for the reply. I thought perhaps append, and was looking at this, still confused a bit though. If I do an append query, does this then allow me to 'append' all the other details and will I have to undo relationships to delete certain records, or does append take care of all...

Hi, Can some kind soul help with pointing me in the right direction to a problem below? In my database (property database), I have some old properties which are now sold. There are relationships between property, rent received, billing, lessees, etc. I want to be able to keep the details of...

Ok, this is what I want to do : I want to 'append' individual records from 2 tables and place in an archive table or within another database, whichever is the best option. I then want to be able to 'delete' the relevant records from one table. The tables are tproperty and trents. This...

Hi, Wondered if SKS can help. I have a query which I have used for a mailing list (in report). However, there are a couple of records I do not want to show. (I just don't need those addresses at this time) How do I go about omitting these two from the query? Is this to do with crosstab...

Bob, Thank you, thank you. This has been driving me mad!!!!!!!!!!! Trying to think logically but understand the jargon, can be so taxing. You have been very kind and helpful. By jove, it works!!!!!!!!!!!!!!!!! Many many thanks Regards Helen

Bob, Thanks for reply. I don't quite understand how I 'make' this column in the query to format month and date i.e., March 2006 Sept 2005 March 2004. Also I have used Sorting and Grouping in the Report to give a Property Header and Footer. The detail mentioned above and costs appear under...

Ah, ok, so I need a separate column (field) in the query showing the 'detail' in order? Then use this field in the report? Also, (hope I'm not too cheeky asking so much), when I look at the query, everything seems in the order I want, such as alphabetically etc. but when I view in the report...

Blimey, that was quick replies! I will try but perhaps explain better. The 'detail' is like March 2006, March 2007, Sept 2006, Sept 2005. and I've managed to get this order in the query Sept 2005, Sept 2006, March 2006, March 2007, so do I just enter these in individually in the 'sorting and...

Hi, Hope someone can guide me in the right direction. Have made a report based on a query. The problem is : On the report, I wish to show 'detail' and 'amount due' in order. On the query, I have used 'sort by' ascending under the 'detail' field. Everything looks fine in the order, but when...