Recent content by Preacha

Can someone please suggest some things that will improve my database? In the payment query the "total paid" field is not updating as soon as you click "update payment" and the booking session form "unbook" doesn't not do the "unbooking" process instantly either, you have to go to another record...

Improvements to the database Just wondering how I would implement this into the database, I am looking into it but haven't really had time cos of other work. Any other enhancements anyone think need to be added? Cheers :)

Here is a copy of what I am doing. Mind the god awful colour of the forms (It's for a womans gym). The payment form is what I am focusing on atm. ISIS Database

Payment Form I was to have a database that will track individual payments of a due payment (i.e. Customer pays a bit one day, and still has more remaining for another day, etc) . I have a "customer" table, a "Payments" table and a "CustomerPay" table (that links the 2). The Structures of the...

I have this database here (http://www.cs.newcastle.edu.au/~c3003364/TrafficCounterDatabaseBETA.zip) I want to create 5 different types of reports I want create a report on "Hourly volume" which will look like this . . . .. On the top of the report should be Site and Direction (from the headers...

Can someone else test that and see if it works, how would I implement it using the above excel example? Does anyone know howto speed up the process of reading files?

Oh yeah and thanks ;)

If I were to specify that particular hours should be listed, I just add that in the SQL code right? I think your idea is much quicker and simpler than my idea. Anyway, do you guys know how I would Go about checking if particular values exist in the table before importing them? This is for a...

Ok, cheers

Never mind I found out DoCmd.SetWarnings False Now, how would I check that a record contains a specific value before I import?

I found out howto do it guys just rst2.MoveFirst While Not rst2.EOF And Not rst2.BOF rst1.AddNew rst1!RecordDate = rst2!RecordDate spdDate = createSpeedDateTable(rst2!RecordDate) inputtable = CStr(rst2!RecordDate & "Table") rst1!Percentile =...

Yeah, if you look on the previous page you'll see that I posted up code from that very page for the percentile function. I need to use that function to create a new table with Dates and their corresponding Percentiles. I was thinking something like this . . .. the createPercentileTable() will...

I don't think that is how percentiles are calculated, but thanks anyway

Look at the PERCENTILE function in excel, its like that. I want it to have the percentile for each group of dates, ie. the percentile for 24/06/04, the percentile for 25/06/04, etc

Once again it still doesn't GROUP BY date, atm it shows 24/06/04 ... 24/06/04 55 25/06/04 54/... 25/ 26/.... I just want to show 24/06/04 Percentile of that date 25/06/04 Percentile 26/06/04 Percentile