Search results

I also tried it the other way: calcdeptnum: IIf([jcphase.deptnum] Is Null,[jcjob.deptnum],[jcphase.deptnum]) and I have the same problem. I just need a way to get the jcjob.deptnum to show up if there is no value in jcphase.deptnum field. Thanks!

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 don't know how many questions I can ask before I overstay my welcome? I am still not understanding what I am doing wrong. Couple problems... If I include the Subroutine line is errors on that line? If I don't include it then is errors on the Set db = CurrentDb? Any thoughts? I'm just...

Thanks. However still getting the same error without that line. I was trying to pattern off some other vb code I had. After I click ok on the error message it always goes to the line: Set db = CurrentDb Are there rules about using this command that I am not following?

I tried simplifying my query to see if that would help. Now I just have: crit = "SELECT tblEstList.EstNum, tblEstList.EstName, qryTruckingDtl.Date, qryTruckingDtl.PhaseID, qryTruckingDtl.Drivers, qryTruckingDtl.DriverID, qryTruckingDtl.Trucks, qryTruckingDtl.TruckID, qryTruckingDtl.[Total...

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...

Two followup questions if I may: I attempted to insert the second query into the Record Source query builder and it messes up the query I had before. Is there a way around this? Second: I went ahead and made a subquery even though I hate all the clutter. Is there a way to remove all the...

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...

How did it turn out? Did you or anyone else figure this out? I am facing the same problem. Thanks!

Any more info? Did you ever get this figured out? I am facing the same problem! Thanks,

What happened? Did you ever get this figured out? I am dealing with pretty much the same problem. Or if anyone else has please say so as well. Thanks.

Any Moren Info? Did you ever get this figured out? I am dealing with pretty much the same problem. Or if anyone else has please say so as well. Thanks.

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...

Wonderful! Thank you.

I made another version here by just dealeting things our carefully rather than copying to excel. This one continues to have the problem that I am facing. This way you can see what I am seeing.

This is very strange. In order to make a smaller version of my database to post here as you suggested I copied a portion of the data from the table I was working with before to an excel file. I then copied the structure of the table from the orignial database and copied the data portion into...

That would be great but I don't know how to do that. Do you mean attach a file to my post? If so I could pare down the data. This query problem is only dealing with one table.