Search results for query: *

...I'm a newbie to this stuff so bare with me.. Rather than try to explain that, let me ask the question differently. Is there a way to stipulate the width of a column (for the query's output) when creating the query?

every time I format a column and save it, provided I don't change any aspect of the query, the columns width remain as saved. Once I change something in the query, the columns display wider than originally set. Is there a way to set default column widths so that changing a date (for instance)...

I'm working in postgresql. every time I format a column and save it, provided I don't change any aspect of the query, the columns will display as originally set. Once I change something in the query, the columns display wider than originally set. Is there a way to set default column widths so...

thanks to everyone for helping! The "and/or" did it!...amazing how a couple missed brackets can screw everything up. Thanks again, pc

Thanks Mercury, but that didn't do it. Let me try approaching this a different way... I asked the database to give me records where the transaction date is between the movein & moveout date using this: AND t.trans_date BETWEEN o.move_in and o.move_out The problem is that it only responded w/...

Thanks George. Bearing in mind this is all new to me... 1. This is PostGrSql. (a bit more disclosure) 2. When I add the column to the table as best as I can tell, I would do it like this: ALTER TABLE trans ADD unit_id INT(20) 3. DB Behavior Question- will the database only populate...

gmmastros, I don't have a unit_id in the trans table. unit_id only appears in the units table or occupants table...Any suggestions?

Hey PH, Thanks for trying. That didn't work. I'm still getting the same duplicate payments....Any other ideas?

Hello All-Hoping for a little guidance. I'm trying to generate a list of persons, their property, unit and their payments within a date range. My problem is that the payments are being duplicated if they lived in more than one unit. Is there a way to only include those units that actually had...