Recent content by fcortes
-
F
less than parameter in query works except when value is 100
CJ.. thank you for reply as well I guess at some point the I think I needed to round up the values and Cint() did the job at that time and it hasn't bother me, (it's been a while I put this thing together and just now came to have some time to do some upgrades) but I will look into your... -
F
less than parameter in query works except when value is 100
bob.. when I used your solution I got my answer.. it works now!.. no more records with 100 on the average.. only the intended records Thank you! -
F
less than parameter in query works except when value is 100
Hi This is a rather odd behaviour I have a query that checks a table where there's a field that only has numbers from 0 to 100 (a grade), let's call that field "average" (note, the values 0 to 100 are actual numeric values, not percentages) here's the problem: when I filter the query using a... -
F
how to pass parameters for "subquery" which record source's query is based of
Re: how to pass parameters for "subquery" which record source's query is based of hi, thanks.. the tie issues is simply that when two students get the same grade, the ranking field obtained with the running sum will not reflect that they're in fact on the same position in the ranking, it does... -
F
how to pass parameters for "subquery" which record source's query is based of
Re: how to pass parameters for "subquery" which record source's query is based of running sum did it for me I just put =+1 for the rank's textbox record source, I had no need to group by class for now as the report is being generated per a class selected on the form and give it a spin and... -
F
how to pass parameters for "subquery" which record source's query is based of
Re: how to pass parameters for "subquery" which record source's query is based of Hi It came across in my google searches while looking for ranking solutions in access but I never tried it out. I will try it and I'll let you know.. the query is basically filtered by Class, which is the... -
F
how to pass parameters for "subquery" which record source's query is based of
Re: how to pass parameters for "subquery" which record source's query is based of Thank you so much for replying here are my queries Query 1 SELECT [All Classes P1 Query].Class, [All Classes P1 Query].[Student ID], [All Classes P1 Query].[Full Name], [All Classes P1 Query].Subject... -
F
how to pass parameters for "subquery" which record source's query is based of
how to pass parameters for "subquery" which record source's query is based of Hi I have a query, called query1, that has a parameter1. I made another query, called query2 that is based query1. I then got another query, called query3, which is based on query2, and is this last query, query3...