Recent content by lflopes

THANKS the error disapeared but... how can I make a "betwwen" with parameters. sometinhg is missing me

i have this crosstab query that works fine TRANSFORM Sum(VoosAeronTbl.ATE) AS SomaDeATE SELECT AeronaveTbl.Registo FROM MissaoTbl INNER JOIN (AeronaveTbl INNER JOIN VoosAeronTbl ON AeronaveTbl.MatriculaID = VoosAeronTbl.MatriculaID) ON MissaoTbl.MissaoID = VoosAeronTbl.MissaoID GROUP BY...

FIRST I have a database on a windows server shared directory (active directory with windows 2003 server). I created a workgroup securit file for this database and I "associated" this mdw file to it. its location is \\server\server\dbase\inverno.mdw When I login from the computer I usally...

Conditional formating is the best. No swet from now on.. Thanks

Hello. I'm triyng to change every field format in a Form each time I jump from one field to another. I want it to get grey and bold when it got the focus I managed it with a GetFocus and Lost Focus for each field but whena form has a lot of fields it gets "a lot" of programing. Is there a way...

Thanks rburna904 rules

I need a query that shows the "not chosen" values. That is: I have table with MANY entry. If I choose FEW (query parameter) how can i write a query that show SOME=MANY-FEW Thanks

I have a table with NAMES, a table with SITUATION and a table with a daily situation for each NAME eg 01-09-2006 nameA SitA 01-09-2006 nameB SitA 02-09-2006 namaA SitC 02-09-2006 nameB SitA For simplifying purposes I want to make a form with 2 two subforms ONE shows who has not a...

I have one query that shows a NAME for each day. Every day each NAME must have one and just one SITUATION. So I'm trying to make a query that shows which have NO SITUAITON yet and other that shows which HAVE A SITUATION already. It must be simple but I'm out of ideas Thanks

I tried to do it also in a form. But I failed...

I have this table AircratfID Flight Time I have a aircraft logbook with 4 entries for page I tried to build a query that shows "Time until this page" "flight time" "flight time" "flight time" "flight time" "Time to copy to next page" Anyone...

I have two tables Table1 fields: Date, MoneyIn, MoneyOut, (plus other fields...) Table2 fields: Date (some <> from Table1, other match), MoneyIn, MoneyOut, (plus other different fields...) Question: Can I run a query that creates a list with field1: all dates from Table1 AND Table2...

Hello. I have this continous forms which gets data from a query. The query has a field that sums date(hours), and I want them to show more them 24, for example, 42:30. If I use general number it shows something like 1.2303256 and if I use short date it show something like 02:00 for 26 hours...