Search results

Is Not Null will not return false value? I have the following iif statement in a query: IIf([jcphase.deptnum] Is Not Null,[jcphase.deptnum],[jcjob.deptnum]) AS calcdeptnum It returns the correct value if the field is not null, however, it does not return the value in jcjob.deptnum if the...

I have a report that groups by Date, Job #, Phase #, Unit #, and then Hours. I have a field in the footer under Hours that is supposed to sum the total hours for that group. And it works fine if there is only one job on the report or for the first job on the report. But if there are two or...

I have a Text Box in a report in which I want to run a module that runs a query. Please let me know if I am on the right track? Here is the VB I have so far: Option Compare Database Dim db As Database Dim rst As Recordset Set db = CurrentDb Set rst = db.OpenRecordset() Dim crit As String...

At least I think of it as an advanced suggestion. I have a fairly good size database (11 Meg) that we have used for a few years to track tons and hours of production. I have a report that we use quite a bit to review said production. This query pulls data from a lot of tables. Here is the...

I'm still relatively new to Access and I want to make a form that allows the user to edit a grouped field all at once (if this is possible?)? For example, lets say there are 13 records in a table and in one column a the type is kept, either 1 or 2. For each type there is a price that changes...

Is it possible to create an unmatched queary between two tables that do not have unique keys, but instead use a combination of two columns that would be unique (for example date and trans# where trans# is unique per day)? Both tables have both columns, date and trans#. If this is possible...

I have a fairly small database I recently built that includes a particular table in which I meant for the primary key to be an Autonumber field. Apparently I forgot to set it this way and it currently sits as just a Number field. There are nine tables in this database with a couple hundred...

I am having a problem that I hope has a very simple solution that I am somehow overlooking. I have simplified my query for the purposes of this question. I have a query that only get the date and amount of a transaction. I want to group the information by date and have the transaction amount...