Search results

Thanks but i prefer to start the week on Monday. Am i right in saying the above will start the week on a Sunday?

yes but currently all the fields are attid of 0 meaning No Record I want the form to load with the weekends pre-populated as attid of 6

So how can i do this? I want to run queries that ignores Weekends SO if a child was Present Monday to Friday in Week 1 Present Monday to Thursday and Late on Friday in Week 2 And so on I want to be able to run queries and reports - that only only look at Monday to Friday. Any idea how this...

If you open the Calendar Form - all the dates are currently grey meaning AttID of 0 If you click on any date - it changes colour. The different colours relate to the different types of AttID AttID of 6 = Weekend. Now rather than someone going in each week and physically clicking on the...

In the process of putting my Student Db together and with the help of everyone here - I'm doing quite well. I have attached a calendar I'm struggling with. I got this from http://www.mvps.org/access/ and have tweaked it to my liking. I have increased the Attendance Type to 0 No Record...

This is great. Can i ask what you did?

Thanks for your help on this. I have attached a sample db. If you open frmSearchqry - For Period 1 of 2008 - i expect to see 8 records (as only one person has paid) For Period 2 of 2008 - i expect to see 7 records (as only two people have paid) For Period 3 onwards - i expect to see all the...

OK the query has worked but i'm having problems selecting a particular month. I have created a search form with a combo box that list the FeeID. However whichever feeID i select it comes up with the same result. Again - i have 10 records. 5 with values above ZERO for Period 1 and five with...

Ah OK - thanks. I see what you mean. I'll try this on my main DB and report back Thanks again

Ah OK - thanks. I see what you've done. You've done it on StudentID is null. I'll try this on my main DB and report back Thanks again

Ok - i have attached a stripped down version of my DB. Open the forms Student and enter fees into the value. If you enter a ZERO - this will show in the qry, If you don't enter anything - nothing will show in the qry. This DB has 10 names. If i don't enter ANYTHING - i expect the qry to show...

Just the 10 i've entered

i've tried Number and Currency

tried that with no joy I removed them via open table I think the issue here is i am trying to get the records in the query result which are not in table My DB has 500 students. I have entered fees for 10 of them By running the above query - i expect to see 490 students of the result but as...

Tried this and it didn't work. Also renamed the field from fees to feesvalue - this still didn't work. I populated the table with ZERO's and then ran the qry - this showed all the zero's. Once i removed the zero's from the table- the qry was blank help

Yes. Like i said if i go into to record and just tab over or enter a ZERO - it reports it via the qry

just the ones with values against them

yes Any field which has not been completed (nOT paid for so blank) - i want to qry in Can this be done?

The fees field is setup as currency - if you go into the form - it shows a £0.00 as default. I have tried the NULL and it didn't work I also took the currency status of the field and made it into a number - this still didn't work Soooo frustrating!!!

Hi I have a dead simple query. Here it is in SQL View SELECT Fees.FeeID, Fees.StudentID, Fees.Fees, Fees.DateEntered, Fees.CollectedBy FROM Fees WHERE (((Fees.Fees)=0)); Basically i want to see those records where nothing has been entered for a specific period - i.e. value of 0 But my query...