Hi all: I am trying to create a query where I need to perform a calculation and/or function to help determine the field name. The situation is this........my...

Hi I have a table containing a Voucher_Number field and a Status field. The Status field data type is text, and records contain values: Used, Expired, Void,...

I have several checkbox fields in a query. I want the checkboxes, "if= -1" to show in another field on the query, the checkbox fields will not show. I have...

I have a parameter query which uses a combo box. When I pull down a name from the list it shows the report with that name. Is there away to show all records...

Hello all, For each group of participants I have two phases, Orientation and Probation. I have the Orientation Start Date and the Probation Start Date stored...

Hi, Hope this makes sense, i am still learning the lingo and correct terms to use. I have a form with a subform based on two tables with a...

Hey folks, I'm attempting to use a random password generating function in a query, but when running the query, the function is only called once. This results...

I am drawing a total blank. I have simple table of three fields: PartNumber, Location, and Price. I need to make a query showing only the lowest price for each...

I have tried to used the IIF then statement to do this but too many nests have forced me to rethink. Is there another function I should look at for this...

I want to close a query when I am done with it in VBA. What's the best way to do it. DoCmd.Close queryname gets a type mismatch?????????????? Mike J

Access 2003 with Windows XP I have two identically structured tables, with names, addresses, and phone numbers. Within each table, the phone numbers are all...

Hi; We want to devide records of a table to 4 equal parts and in each step work on one part of them.For now,i can just select the first part,using...

I am trying to create an active employee list. Essential table structure is as follows: tbEvents (a table holding all employee and applicant...

I have created a query which I want to use to filter out all records in a table that have an entry in a certain field. The field will contain text - therefore...

My cursor jumps all by itself to wherever the mouse pointer is. It does this after typing a few characters. I'm typing a line. The cursor is of course at the...

How do i remove an append query?

Hi I have used an example from the Northwind sample database to write a query to show running totals for the current year, but I am hust getting an error in...

Seems like something simple, but I can't figure out how to do this update query (for just one column in the table.) I need to replace first 6 numbers with an...

I inherited a database in a mess. I ran a query to get following columns: salesman first date (first date of sale to company location) last date (last date of...