Search results

I have a report with a group header that distinguishes type1 from type2. I also have the heading for the columns in the group header. Depending on if it's type1 or type2 I would like one of the headings to change. Example: Type1 Name Address Phone Steve 12 Maple 911 Mark...

you'll want to couple that with the on update or on change of the checkbox.

similar, but different question to my first one. I have a problem table, it has startdate and closed date. i would like to know how many problems were unsolved in given month. ergo the start date is less than or equal to some month, and the closed date is null or greater than that same month...

Nevermind I think I figured it out. I don't know if it will span years though.

how do you use these functions. I mean where do you type them in, etc.

I'm trying to get data on the number of problems we have open on a given day/month whatever. but I"m completely stumped I know how to query the db if the problem happened during this month or last month, but what I really want is the total number of problems divided out by the months they...

awesome thanks sorry if this was an extraordinarily dumb question. :) danke

NOTE: "\n" does not work. What do I use instead?

How to I do a new line in a string. I'm trying to make an address line in a text box so it reads like this [fname] & space(1) & [lname] & "\n" & [address1] & "\n" & iif(isnull([address2]),[City]&", "& [State] & space(2) & [Zip],[address2]&"\n"&[City]&", "& [State] & space(2) & [Zip]) If i was...

OK I'm trying to run an update query. I have a table from which I wish to get a large amount of my data, it's a table that's sort of denormalized so we our users can run simple queries on it and get a variety of data. Here's what happens: When I use the denormalized table, call it foo, and...

no problem. I hope I haven't oversimplified your question. If I misunderstood or this doesn't work let me know. Thanks, Seth

=count([column to count]) if you're just counting the number of records to return.

=sum([column to count]) if you're trying to count a number field

Either works. I'd like to put them in a single query, but I suppose I could chain them one after another. I've put together a VBA module with a docmd.setwarnings false and openquery qry1, etc, but I don't the compiler keeps telling me I need to put it inside a procedure. What's up with that.

Is there anyway to chain together my queries? eg, make table blah blah blah; update table blah blah blah; update table blah blah blah; update table blah blah blah; update table blah blah blah; alter table blah blah blah;

structured at the moment. Here's the problem I can create a column with alter table tablename add column bob text notnull; for instance but I don't know how to add more than one. TIA, Seth

Any way I can add a column or drop a column in a query?

I'm using something to get the month from a birthdate, but I can't get a leading zero on the month. is there a function to do this, e.g. newfunction(month([birthdate])) tia, seth

sorry to be such a pest but i dont' seem to have an index, at least if I do it can't get to it that way. I'm using 2002. I tried typing index in clippy and I got stuff about how to index my tables :(

where is the access online help. I'm assuming you are not talking about the paperclip guy.