yes i have tried using a filter but with no luck
i want to set a filter thats says:
SELECT* FROM MyTable WHERE RecordCount < 20............ where recordCount is the number of records i want to see in my report
is there any way to do this?
hi guys!
i hope someone can help me with this problem
i have a report thats get data from a query but i only want the first X records in the report. how can i tell the to show only the first X records
i have tried everything i know...please help!
yes your regional settings is english ... but whos english, remember that america also speaks english.
you can specify the date format you want by clicking the date tab in the regional settings diaog box or changing your locale to english(Jamaica). this works if you are running Windows 2000 i...
I AM BUILDING A DATABASE TO STORE STUDENT RECORDS AS WELL AS MONITORING AND OTHER INFORMATION FOR A RELATIVELY SMALL COMPANY (30 USERS MAX). MANY REPORTS WILL BE GENERATED BY MANY DIFFERENT USERS CONCURRENTLY BUT IT IS UNLIKELY THAT MANY USERS WILL BE UPDATING RECORDS. HOWEVER THE DATABASE...
there is no isNotNumeric function but u can do it this way
If Not IsNumeric(Me.EstimatedRunTime) Then
strMsg = "The fiels Estimated Run Time has to be a number - it is the Run time in minnutes"
MsgBox strMsg
Else
DoCmd.DoMenuItem acFormBar, acRecordsMenu...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.