Recent content by cablegirl

I finally got it to work FFRating: DLookUp("Rating","Criteria_Ratings"," [FFMin] <=" & [FF/M] & " And [FFMax] >=" & [FF/M] & "")

Thanks Pat, what would you suggest would be the best way for me to get the data I require?

Hi I hope someone can help, I believe I have a problem with my setout but can't quite nail something that works.:banghead: I have two tables Criteria_Ratings: FFMin FFMax Rating BaseData: FF/M What I am trying to do with a Dlookup is return the Rating when FF/M is between FFMin and FFMax...

I have a problem which I can't seem to work out and I am sure there is any easy fix. I have two tables that have information based on the depth down a drillhole. The tables are linked by HoleID. One of the tables has surveys at intervals down the hole eg. 30m, 60m, 90m, the other table...

Thanks wiklendt it worked. I had to change the Station Name SQL but after that it works perfectly. Thank you for your help.:) missinglinq - sorry about the Access 2007 I will make sure I post it next time.

I have an issue with my cascading combo boxes on the attached database. When I change the Decline and then the Station Name it copies the first row in the table back into the table with the Decline and Station Name changed. I know it is not the best form as I have set it up to change the...

I am not sure if I completely understand you but I have created a report from a form where all of the fields on the report are unbound boxes which related to the form fields rather than the table or query eg. =[Form]![formname]![field] so that when I print the form the only results I have are...

Hi all I am having a problem with a graph I have set up on a form. It is an XY scatter graph which I have set up with MS Chart that displays one value from a query. Sometimes when I open the database the x value reverts to one and I have to open MS chart and reselect data by columns. The...