Search results

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

Yeah, but that doesn't group by Date, if you add GROUP BY SpeedImport.RecordDate It comes up with an errror message saying that speed is not part of the aggregate function. Any Ideas?

This is wrong but is this the general idea on how you do it. Btw Wayne thanks for your help with importing files, it works well. I may have some later issues later tho :P SELECT SpeedImport.RecordDate, (SELECT TOP 85 PERCENT SpeedImport.Speed FROM SpeedImport) FROM Headers INNER JOIN...

This TOP 15 Percent thing is intriguing, how would I go about using it?

What if I create a table called "Dates" that lists all the dates and somehow use that to group the 85th Percentiles using those dates? Does anyone know how I go about this?

I found code for VBA on how to do it. I Was just wondering how I would implement this so that it groups the speeds by dates Public Function PercentileRst(RstName As String, fldName As String, PercentileValue As Double) As Double 'This function will calculate the percentile of a recordset...