hi all i am trying to creat a qry with parameter for a specific period of "Travel" Dates like this betweenand but i want it to show all records if i leave this...

I have a table with multiple columns. The primary key is the column titled "Property Address". Each property contains it's own row. There is another group...

Hello all, Somehow, my brain is not working today. Can you help me with a formula to remove spaces for my select query? For example, I have a text field...

I am writing a query from a table. This table pulls from a form that has an age calculation in one field. This result does not store in the table, and I have...

hi i have a data set where a customer can have product A, B, C, D, E or F with a specific value what i want to produce is a table showing where a customer...

I have several forms that I need to use the same query (one at a time) each form has a field with the same name on it that I am using to pass criteria to the...

Hi all, Here's a mystery I need to find a work-around for. Maybe someone has a simple solution. As part of a de-duping process, I'm finding duplicates...

I am using Access 2007. I am trying to create a query that will select a particular cell at an intersection of a particular row and a particular field name. ...

have created a database for Payments entry for various parties in which I have created a Select Query for obtaining the Bill Details (Advance, Running &...

Hi all again!..i am struggling wit the following issue… � In a table I have the following fields that are part of a...

I am runing into an issue though that is really going to aid me in making my counts for my Marines and Sailors. I have a database at work with personell...

I have a some action queries within macro that I want to execute, but when I fire off the macro there's some informational messages that I want to supress. I...

Hi, I would like to know if there is a way of knowing if a year is a leap year. I m trying to build a report that has the 12 months of the year with the...

I have data that has possible 3 characters & up to 10 numbers & up to 3 characters after the numbers. for example A 012345678 BZ Displayed as A012345678BZ A...

Can someone see why I would only get a result for the month of April in this following query. The qryUtilization has data from 1/1/08 - 12/31/08? TRANSFORM...

Hi This query, which is basically returning a record set of names NOT in another query is taking 15-30 seconds to run. Is my structure making it so...

I have a query where I want to show either a single selection from a drop down box, or all records if the dropdown box is null. The language I'm using...

I’m trying to write an IIf statement in an Access query that I’m having problems with. I want to calculate the number of days between a Date Received...

I have two combo boxes on a form, each control has a lookup table with an ID and a Name. The rowsource in the property box only selects the Name column...

I have a query based on phone numbers. My database distributes billing based on the number of hours each month an individual bills to a certain project. The...