Login or Register to Ask a Question and Join Our Community


Windows & DOS: Issues & Discussions

selection criteria in Access query not working

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Special Forums Windows & DOS: Issues & Discussions selection criteria in Access query not working
# 1  
Old 03-27-2009
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-t1designjpg
selection criteria in Access query not working-t1datajpg
selection criteria in Access query not working-q1designjpg
selection criteria in Access query not working-q1datajpg
selection criteria in Access query not working-f1datajpg

# 2  
Old 03-27-2009
Tools There are forums perhaps better suited to answer Access questions
Perhaps try:
UtterAccess Discussion Forums - Access Help Center Index
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. 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... (5 Replies)
Discussion started by: navkanwal
5 Replies

2. 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... (12 Replies)
Discussion started by: siramitsharma
12 Replies

3. 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... (10 Replies)
Discussion started by: gangsta
10 Replies

4. 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 ... (2 Replies)
Discussion started by: DevendraG
2 Replies

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... (1 Reply)
Discussion started by: rethink
1 Replies

6. 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... (6 Replies)
Discussion started by: balaeswari
6 Replies

7. 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... (0 Replies)
Discussion started by: hazno
0 Replies

8. 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... (8 Replies)
Discussion started by: cooljumbo2k8
8 Replies

9. 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! ... (1 Reply)
Discussion started by: GEBRAUN
1 Replies
Login or Register to Ask a Question