Search results

I currently have a qeury that calculates a value, this value can be anywhere from 0 - 3000, I then need to use this value and lookup in a range in a table. This table has three columns, (Min, Max, Setpoint) I currently use DLookup("Setpoint", "TableNamee", "Max > Calculatedvalue")) I use...

I have a report with one subreport, they are linked with a master/child. The main report is linked to a query, and the subreport is continuous report, so I could have no records or I could have 10 records in the subreport. What I am trying to do is in my main report, I have 3 unbound...

I have a report and in that report I have a continuous subreport. they are linked by roomnumber (master/child) The subreport can have anywhere from 0 to 10 records (each record has 5 textboxes with diffeent values). In the main report, I also have ten textboxes. If the subreport does not...

I need to use an exponant in a query, it works fine as long the exponant is a whole number I receive an #error in the feild with the expression below. DoorInfiltrationCFM: [DoorPressure]^(0.5) How can I use a decimal number as exponant. Thanks

I have two tables, roominfo and exhausttypetable. In the exhauasttypetable I store the name of the exhaust equipmenttype, MAXCFM, MINCFM, and some other info. In the roominfo table, I have 10 fields named, exhausttype1, exhausttype2, etc. I have a form that enters info for the roominfo...

I have a form and when I open it, the access window is hidden. I also have created popup menu when I click a command button, the menu works fine in the form, but only if you do not hide access window. I get an error message Does anyone know how I can do both, This is the code i use to hide...

Hello all, I have two tables, one is roominfo and the other is roomtypes. Each table has about 10 fields, and have a relationship based on one field in each. I have added a qurey that links the two table together, all records in the roominfo are shown in the query. The linked field has a...

I am new to Access, and have search for many post and have set up my database to some of waht i want but I neeed some help to do make it more complex. What I have, or will have, is about a 30 tables, each table has the same fields, but has different information. Each tabel is compiled of many...