Search results for query: *

Hi Guys/Girls, Thanks for your help. I have a simple report based on a crosstab query. The data coming back is correct, but it seems to "jump" zero's a line above any field with a value in it... Looks like this... (Header) Name Jan Feb Mar Detail 0 0 JRM 32...

Michael, I apologize...there are only 233 fields/columns. I had already cut and paste about 100 of the names into the old fashioned method and I took a guess at it. So really I only want to move 228 of the fields into my "export" table from my 233 field "original" table...

Hi Guys, Please help. Gotta be a simplier way question.... Trying to write an append query from a table with about 270 fields. The problem is I only want 265 of the fields added to this other table, as the other 5 fields are not to be "passed" on to it. The table with only 265...

Hi Access Experts, I've got a form I'm designing that I'm not sure how to set up the correct programming for. Hopefully some of you can help...(please!) I've got five buttons on the right hand side that fire off different files to be saved on the A: (one at a time of course). These are...

I'm very new to "designing" Access applications and I was hoping one or more of you could give me a little guidance. I've come to the "fork in the road" in this project and I'm just hoping someone can point me in the most efficient direction I should take... Here's the...

princeT, Ughh... I think the problem now lies in those other conditions that you are putting in the "having" part of the query. But try this first.... Change this part of the select statement... Last(DateDiff("y",[tblTRAILERWASH].[WashDate],Date())) AS DaysSince to...

PRINCET, I messed up with my first post as I didn't read as thoroughly as I should have, with trailermaster and trailerwash existing as seperate tables. With a footnote to benjamenus, look at this... SELECT TRAILERMASTER.TRAILER, First(TRAILERWASH.WashType) AS WashType...

Is the Wash Date field a date/time field or is it a string field that uses some mask to look like a date...I'm hoping its a Date field, otherwise my little sample won't work... Wouldn't it be something like SELECT [TRAILER MASTER].Trailer, [TRAILER MASTER].WashType, max([TRAILER...

Thanks for your help.... I've got a cross-tab query that I want a report from, essentially a repair type per worker table. Here's my problem... I need to be able to show the recipients of the report the "column totals" where the values are "null" also..ie zero. When I...

Robert, Thanks for your help. I got just mentally locked up on something very easy, and I appreciate you taking the time to help me out. Thanks again, Andy

Okay, this has got to be easy but I'm new to this so please help me out. Have a nice form that's working great. I get two user numbers from this form that I multiply to get a number (X), now I need to use this number to bring back the first X rows from the query (base) created from the...

Thanks very much for your help. This has me started in a good direction... Thanks, Torn

Okay, I've been reading the forums for awhile trying to pick up as much as I can, but now I'm stuck. Hopefully some of you can help me out here. I've got a development problem. Nice Access 2000 db, forms all created, etc. Table 'Problems' contains all the problems my users are having. No...

Okay, I've been reading the forums for awhile trying to pick up as much as I can, but now I'm stuck. Hopefully some of you can help me out here. I've got a development problem. Nice Access 2000 db, forms all created, etc. Table 'Problems' contains all the problems my users are having. No...