Search results

I don't know if that's possible in my situation. There are 102 Subsystems involved so my SQL would go something like: SELECT [CatSys] (SELECT[CatSubSys]FROM[SubSysTab]WHERE[CatSys]=[SysTab].[System]AND[CatSubSys]="SubSys1") AS SubSys1x...

I forgot to change the crosstab2 query. the fields listed there are the actual system names, just so you're not confused.

HMMM.. I don't see the attachment. I'll try again.

OK... This is an extremely watered down version of the db (hope it uploaded correctly). As you can see in the queries, the first one works the way i want it, with the subsystems listed underneath the correct system, as opposed to the table version of the data. I tried going in to the...

Thank you Wayne... I thought I was talking to myself for awhile. Unfortunately I don't even know what to do with that. :confused: Looks like the hunt is still on. MJ

I forgot to mention, obviously that's not a completed version of the SQL as each system will need it's own subquery when I get this thing to work.

Okie Dokie... Here is where I'm at now. I'm writing a second query based on the crosstab and the main table. When I input a subquery to pull up the status column, I get an error that says: 'the ms jet database engine does not recognize '[crosstab1].[catsubsys]' as a valid field name or...

Ok... In my cross tab query, I currently have the systems set up as row headings and the subsystems set up as column headings. In each cell is listed the name of the subsystems again... which is completely unneccasary. I would like to put the Status in the cells, but when I try I get some...

I can't seem to get it. I tried to write an additional crosstab query for the Stat column, but I can't seem to figure out how to map it to the SubSys column so I could union them together. STILL workin on it. MJ

I managed to get the two put together with a cross tab query, which is groovy. There is a third column that I need now which is giving me a problem. The actual setup needs to be: Sys1 SubSys1 SubSysStat1 Subsys2 SubSysStat2 Sys2 SubSys1 SubSysStat1 Subsys2...

Here is how my table is set up: System1 Subsystem1 System1 Subsystem2 System1 Subsystem3 I need a query that puts the data into one record, different cells: System1 Subsystem1 Subsystem2 Subsystem3 Can this be done? Thanks, MJ

Still trying to figure this one out. Have over four hours in on this one problem yesterday, and another hour today. Can anyone point me in the right direction?

Hi all. I have a form with two lists on it; systems and subsystems. When I click on the system listbox, I want it to filter out just the applicable subsystems in the next listbox. The table that they are looking up has the systems as column headers with subsystems listed under each. So...

Hi all. Anyone know where I can find third party no-install exporting software. I need to export to HTML and maintain all my formatting on a report. Thank you, MJ

Workaround All is good. I kept the date/time filed in my table but just added two more fields for the form to work with, date and time obviously :). There might have been a more kosher way to deal, but this works for me. Thank you all for checkin' in, MJ

Here is the code that combines the two fields into one: Private Sub Form_BeforeUpdate(Cancel As Integer) If (Me.txtTimeDown) <> 0 Then If (Me.txtDateDown) <> 0 Then Me.txtDateTimeDown = _ DateValue(Me.txtDateDown) + TimeValue(Me.txtTimeDown) End If End If End Sub

Hi all. I have a form with two fields that modify one cell in my table. The two fields are date and time, the cell being date/time. The control source is the same for both, and the format is set to short date for the first and short time for the second. They both pull up the records just...

I thought about that and that's the direction I'm moving in now. For anyone following along because they have a similar dilemma, a union query alone didn't work, as the values for regular hours and OT hours came up as two different rows for each date. So... I wrote ANOTHER query which...

Are the values for those individuals zero, or are they null values? If so, I believe you have to use the Nz function to incorporate them into mathmatical functions. Matt

Alrighty... My DB contains the following tables: VacTab - Keeps track of crew members on vacation and people covering their shifts. CrewRost - List of all the crew members and what crew they belong to. CrewSched - The complete schedule of what crew is working which shift (Currently programmed...