I get "You cacelled the previous operation." error when I try to run a query. I have a form with two drop down boxes, a begin and a end date and a button that...

Hi, I have a table to which I am trying to manually add a record. When I add a record directly to the table using query, I receive the error message "You...

Hola Amigos: Hace unos días recibí un mail donde me invitan a hacerle un regalo de amor de $1 dólar a seis personas y después ponerme en la lista para que...

hi, i have been working on this query forever. looks like u cant use dlookup functions within a query. is that right? i have: SELECT Tbl_archive.,...

using A2k; seen LOTS of posts about this topic, but none seem to address the heart of my question. Let's break this into 2 parts: queries (stand-alone); and...

Hi I've searched all around the net, but no "solution" seems to do what I'm trying to achieve. I have a database that imports data from a group of Excel...

I have a query where I am trying to pull the Project Number, The Resource Role and the Actual Hours worked for the month. I have seven roles that I track and...

I have a legacy database in Access (presently 2003), containing call logs. There is a query that returns all calls that occurred within a specified time frame...

I've read through the many many threads already here on this subject but can't seem to translate what I see in those answers into solving my query - I realize...

hi, I'm having problems with a calculated control and a field in the table. What I have is a form with a calculated control (nr_of_teams) that counts how many...

Need help i have a value list of Row source type: Value List Row source: -1;"Yes" 0;"No" "*";"Yes/no" everything is fine except for yes\no value

When running my query, I want it to pick up only yesterdays visit dates, but when its a Monday it should show Fridays visits. How is this possible? i dont want...

I am thinking I am missing something very elementary, but regardless I'll ask. I have a form which when a user runs a query specific based upon their user id...

Hi all.. I have a query pulling from the main table that has two yes/no check boxes. The query works fine when I have just one of the yes/no marked...

I have set up a union query that displays a yes/no field. On the original table the results show as a yes or a no, but in the query they show as a -1 or a 0....

Greetings all, I am attempting to create what seems (to me at least) to be a very complex query. I have a form (which will eventually link to my query when I...

I have a set of products we produce and when people enter a product change request they check the product that the change applies to. I would like to run a...

Hi Im trying to run a query and I want to filter on field that has a yes/no date entry (in my table its in the form of a checkbox). Im sure this should be...

I'm setting up an awards database. I'll have 30 people and 50 awards. I need a querry to select LastName and only pull up the checkboxs that are checked yes....

I have a form that has six different yes/no boxes for different divisions of the company and whether jobs are completed or not. I can't seem to get a query to...