Search results

Thanks Thanks Neileg! I'm nearly there! but I've ran into a new problem. The subreport isn't linked as the records will be different (only thing the same is the layout and fields). Which is fine. I'm using BETWEEN AND function to create criteria for a date so that I can be specific with what...

I'm designing a report that has a Currency field. I want the report to show all the records that have an entered amount and below these records I want to show the records that have a null value I thought it would be as easy as the following textbox: =[£_Sent] Is Null and the second textbox...

I've posted something similar on the queries section and thought it would be clearer if I explained it here. I want to generate a report that will show records from a multi-table query. The two main tables are "tblProject" and "tblDisbursal". these tables have an indirect one - many...

Still not sure Thanks for the reply Rabbie! Would that still work in the following senario? If I want to use a query for a report that would show all Projects ("tblProject" residing in the parent table) and only the last added disbursal records (tblDisbursal" indirect table relationship) for...

I'm fairly new to SQL and have a problem finding the latest record. Lets say I have a development project that has many disbursal payments to be sent. I want to find the latest disbursal record created for that one project instead of having all of the disbursal records show on the query. I'm...

Hi folks Ok, this one is quite simple, I just keep getting bother with it. I have a Form with a bound txt box. I want this forms control for that record to show in another form which is a continious form I've tried this =Forms!frmProjectDetails!tblCommitteeDetails.Form!FundingFromDate The...

Ok, this is ridiculous I know, however I've tried looking everywhere and keep coming up against ridiculous barriers. I'm trying to change the background colour of the actual form as apposed to a control. The palette is very limited with 40 colours and doesn't even contain the default grey...

I've sent a post about this before and got some of the answer from 'Dennisk'- thanks. I want to replace composite keys with a primary. I've just made an autonumber field on one table for my new primary key and already populated it. On the foreign table ive made a new field with 'number'...

Ok, here goes... I'm working on a database with 15 tables. most of the main tables have composite keys. This is probably because when it was designed there was alot of present data. I'll call the composite keys "PrefixCode" which makes up a country & "Code" which makes up a project within...