You will want to use what is called an "outer join" (Google this). I can't tell exactly which tables you want to use this on, as the labels you used in your description do not match anything from the query.
-V
It is possible that the data is not being imported correctly and the field is being filled with the "Default Value" (which is 0 by default). Are all values "rounding" to zero or are they rounding to other integers as well?
If they are rounding to other integers, make sure that the decimal...
I am looking for a library within Java that would allow me to read in two XML schemas (via XSD files) and decide whether they are equivalent, up to changes to whitespace or reordering of child nodes. Does anybody know of any such utilities? Thanks.
-V
I have a situation in an application where I want to see if two interfaces are compatible (that is, have the same methods, fields, but possibly defined in a different order) by looking only at the IDL files for these interfaces. Is this possible, and if so, is there a utility to do so within...
Update: I've fixed the symptom by changing the form's RecordSource to null, saving and then setting it back to the table. However, I would like to understand why this happened in the first place rather than just treat the symptom whenever it happens. Does anyone have any ideas?
-V
I've designed a database in Access 2000. It has been working fine for the past two weeks. However, this morning when the database was opened, one of the forms seemed somehow locked.
No data could be updated within the form. No new records could be added using the form. The form has a table as...
It may not cause problems, per se, but normalized tables such as Remou's will be easier to extract data from. You should be able to normalize your data with a UNION query. A slightly modified version of a query found here could help: thread703-1394788
-V
AS you can see from http://www.goascii.com , the ñ character has ANSI code 241. If you are on a PC, you can create this character by holding down the shift key and typing 0241 on the numeric keypad and then releasing the shift key. This can be done for any ASCII or ANSI character.
-V
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.