Search results

This does exactly what I want now! WHERE MONTH(READINGDATE) = [Enter the Month Number] AND Day(READINGDATE) = [Enter the Day Number] Thanks for your time and help Oh, and yes I will investigate the WHERE Clause

Just wondered if I have to have a field called ReadYear in the table so as to select the year. I hope not as there are over 5000 records I would have to go through! Thanks

yes there was a small problem at this end as to why I was asked for a READDATE. My apologies as I should have said the field was ReadingDate and not ReadDate. I have other tables where I have ReadDate, and the one I used is ReadingDate, hence the confusion. So now I am asked for a Month Number...

Yes it does ask for a ReadDate, as I have just tried it again.

Some example ReadDates: 01/03/2004 16/09/2008 11/02/2009 27/11/2010 The UK date is day first

I have just tried a split form with date filters, which kinda works. Using the SQL code, when I click on 'run' as it were, I am asked for READDATE from a parameter window, then asked for a month number, and after entering the values I get no records . Aah, but then I entered August 5th for the...

The table has 6 fields: ID PK ReadDate TempMaxC TempMinC RainFall Conditions There are just over 5000 records in it, and would like to maybe display a month's worth at a time.

Ok, I have now got a form with 4 fields on , which is all I want for now. There is a read date field which obviously only shows 1 day. Is there a way I could have it to display a months worth of data. Thanks

I have over 100 queries of weather data, for each month, and would like to display certain or filtered information for a selected month. I have been playing around with a combo box to select a month from a given year, and was hoping that maybe an 'After Update' would do what I want. The problem...

Thanks, and that is what I have ended up doing. On both the GasID and ElecID fields, I have created an 'onclick' event so that the relevant subform opens up.

Yes it does look like subforms is the only way to go with what I want. Thanks

I was only sort of just thinking about Child forms, as many years ago I did use them for one db I built, but moved on a bit since then. We get out dual fuel bills monthly , where they consist of an overall usage and payment on one page, then on a second page, all the figures are clearly broken...

Ok, I have just created another query using just the tblMain, and although the GasID and ElecID are also in the said query, when the form is loaded up it only shows records from tblMain. There are text boxes for both GasID and ElecID but no others, which is kind of obvious in one way. So doing...

Ok I think I have now solved this. After doing some checking on the PK's, and then closing down the db. Then reopen it, and in the main form when a date or any data is added, some data MUST be added to both the Gas and Elec parts of the same form. I then saved it without any error message, and...

Yes I see what you mean now but as all 3 tables are in 1 query so to speak, and the the form is created from the said query, the GasID field is in/on the form. Anyway, how do I get a related record in tblGas. Do I change the PK in tblMain to GasID? Thanks

Apologies, I made a bit of an error when I posted my initial message: This is how I related the 3 tables tblMain BalanceID PK GasID ElecID tblGas GasID PK BalanceID tblElec ElecID PK BalanceID tblGas is related to tblMain by GasID tblElec is related to tblMain by ElecID I am only guessing...

As the title says I have 3 tables: tblMain BalanceID PK GasID FK ElecID FK tblGas GasID FK? not sure BalanceID tblElectric ElecID FK? not sure BalanceID I created 1 query from all 3 tables, then created the form from that 1 query. Now when I enter data into the form and click to save it ...

I sort of solved this problem by using 3 separate tables, 3 separate queries and 3 separate forms. I then put 2 forms on a main form, which does what I want. Its not exactly how I wanted it but if that is the only way, it'll have to be.

Yes it is a 1 to many, or 1 to 2 in my case, and I have been thinking that I would have to use 2 subforms on the main form. If I didn't have 3 tables and only 1 with all the fields on, then it works ok without subforms. Thanks

The main table is the tblEONE....., which as you know has an ID with autonumber Regarding the ID numbers in the other tables, that has only come about due to me starting over and over again when the main form did not save the records, and at that time not realising they were in one or both other...