selection criteria in Access query not working Post: 302301611

Sponsored Content

Special Forums Windows & DOS: Issues & Discussions selection criteria in Access query not working Post 302301611 by hipockets on Friday 27th of March 2009 12:29:00 PM

03-27-2009

Registered User

selection criteria in Access query not working

Attached are views of the components of a dummy Access database. The database represents an example of the problem that has reared its ugly head.

The query example is a simple "Selection" query, which, after getting it to work, will become an "Append" query. The selected data will be appended back to Table T1.

The problem is that the selection criteria in the query does not work.

The same problem occurs on some text boxes in the customer's database -- but not on all of them.

I have compacted and repaired the database, and ran AVG and Anvira AntiVi.

I have thought about reinstalling Access -- but the problem occurs on both my computer at home and the customer's computer.

On both my and the customer's real databases, I have tried deleting the offending text boxes and queries and reinstalling them with no improvement. I also tried deleting and reinstalling the form, with no improvement. This might sound crazy, but it has helped in the past with similar problems

I use XP Pro, SR3, 1 gig memory, no other programs loaded except AVG and Process Explorer, plenty of hard disk space, a 1.8 CPU, and Access 2000 9.0.2720.

I will appreciate help!

David Colbert

selection criteria in Access query not working-t1datajpg

hipockets

View Public Profile for hipockets

Find all posts by hipockets

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Export Query not Working in Shell

I am exporting data using a shell program. I am getting all of the records instead of getting a subset based on my query. The export_problem.par lists all of my tables. I tried the query with the ' and without it. How do I get the export to use the query? Thanks! ...

2. UNIX for Dummies Questions & Answers

Remote Access to FTP server not working

I am trying to setup an FTP server in a Fedora Core 3 machine through the command line interface and not KDE. I think I am successful in getting the ftp service running, as when I do an ftp 127.0.0.1, I am able to log in using any one the user accounts I have created on this machine and browse...

3. Shell Programming and Scripting

add the output of a query to a variable to be used in another query

I would like to use the result of a query in another query. How do I redirect/add the output to another variable? $result = odbc_exec($connect, $query); while ($row = odbc_fetch_array($result)) { echo $row,"\n"; } odbc_close($connect); ?> This will output hostnames: host1...

4. Shell Programming and Scripting

Query Oracle tables and return values to shell script that calls the query

Hi, I have a requirement as below which needs to be done viz UNIX shell script (1) I have to connect to an Oracle database (2) Exexute "SELECT field_status from table 1" query on one of the tables. (3) Based on the result that I get from point (2), I have to update another table in the...

5. UNIX and Linux Applications

MYSQL: Help understanding this working query

Hi there, I have a query that works just fine, but im having a little problem understanding how it works and have been struggling to find any docs that explain the techniques that are being used. If anybody out there could explain how this is put together then that would be great I have three...

6. Shell Programming and Scripting

Shell Script to execute Oracle query taking input from a file to form query

Hi, I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database. For instance: USER CITY --------- ---------- A CITY_A B CITY_B C ...

7. Shell Programming and Scripting

If Selection statement

ok im kinda stuck i have a bash script with 4 options 1. Create Script 2. Show Script 3 . Delete script 4. Exithow would i use an if statement for this? im not sure what test command i would use. I know it would be like this (below) to display the script if then cat script1or for the...

8. Shell Programming and Scripting

awk not working for calculating no of lines with criteria

I have tar.gz file and i want to count the lines which are matching the criteria as well as which are not matching the criteria. Following is the code Output Requirement: Match the input from zcat with 26th filed having 02 value, in case it matches then print the output in a file & increase...

9. Red Hat

Root Access not working as FileSystem in ReadOnly Mode

Hi Experts I am facing a problem wherein Root Access not working as FileSystem in ReadOnly Mode. Due to a Disk failure, my Filesystem went into Read-Only mode: report@xx> grep root /proc/mounts /dev/root / ext3 ro,data=ordered 0 0 Now, I am not able to login using root user on the...

LEARN ABOUT REDHAT

split

SPLIT(1)								FSF								  SPLIT(1)

NAME

       split - split a file into pieces

SYNOPSIS

       split [OPTION] [INPUT [PREFIX]]

DESCRIPTION

       Output  fixed-size  pieces  of  INPUT  to PREFIXaa, PREFIXab, ...; default PREFIX is `x'.  With no INPUT, or when INPUT is -, read standard
       input.

       Mandatory arguments to long options are mandatory for short options too.

       -a, --suffix-length=N
	      use suffixes of length N (default 2)

       -b, --bytes=SIZE
	      put SIZE bytes per output file

       -C, --line-bytes=SIZE
	      put at most SIZE bytes of lines per output file

       -l, --lines=NUMBER
	      put NUMBER lines per output file

       --verbose
	      print a diagnostic to standard error just before each output file is opened

       --help display this help and exit

       --version
	      output version information and exit

       SIZE may have a multiplier suffix: b for 512, k for 1K, m for 1 Meg.

AUTHOR

       Written by Torbjorn Granlund and Richard M. Stallman.

REPORTING BUGS

       Report bugs to <bug-coreutils@gnu.org>.

COPYRIGHT

       Copyright (C) 2002 Free Software Foundation, Inc.
       This is free software; see the source for copying conditions.  There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICU-
       LAR PURPOSE.

SEE ALSO

       The  full  documentation  for split is maintained as a Texinfo manual.  If the info and split programs are properly installed at your site,
       the command

	      info split

       should give you access to the complete manual.

split (coreutils) 4.5.3 					   February 2003							  SPLIT(1)