Hi all, I have two joined queries with the same field names for both the queries. one of the fields is called "MaxofAged Days". I want to make one query that...

If I use the following expression as search criteria in ANY column of the design grid, execution of the query will return correct...

I am having trouble with a query that is supposed to sum all sales. For some reason it is excluding some records, like when I have a sale for the same...

I have a large data feed that comes in and is mixed from two sources. One part concerns transactions in NAmerica, the other the rest of the world (reflects...

I am trying to get my command button to open a Form rather than a report. I tried messing with the VBA behind the command button which gave me the...

My question is very simple for you experts. I have a list of phone number in a table and some phone numbers were entered incorrectly because they are less...

On Jul 10, 1:35*pm, pat67 wrote: On Jul 10, 1:33*pm, pat67 wrote: On Jul 10, 12:46*pm, KARL DEWEY...

On Jul 10, 1:33*pm, pat67 wrote: On Jul 10, 12:46*pm, KARL DEWEY wrote: Post...

Hi, I am using Access 2003 as Front end and Sql backend. I have a cross tab query which spits sales by sales rep for month 1 to mth xx based on the...

Is it possible to do an Iif statment in a query based on 2 conditions? This is what I currently have (if dates are not in the same month put correction...

I have a list box on a form that has information that changes based off of a field on my form. For example, in a text box if I put "RED", the list box shows...

Access03 Ok I have an unbound search form with an unbound input field named 'txtNumber'. The field is used to search for a number ie 09-0001. This is how the...

Hi, I created a similar database for use in 3 different centers, the only difference between the data from these centers is the first letter of the subject...

I have a 30k row table. There are dupe tax id's because there are multiple doctors per an office. I have to run a query to add the phone number and fax to this...

Thanks to Jeff boyce for his response to my question (do I need more indexes?) in the database deisgn group. Individual reports created throughout the year...

I am new to VBA programming in Access, though very comfortable using queries and macros. I want to know if the following can be done without VBA, and if so,...

I have to field with time. It should be easy but having lots of problems. eg 7:00 AM - 8:30 AM = 1:30 11:45 AM - 12:30 PM =0:45 How do I get this to work...

I have a database with two tables, each with a numerical primary key field and a name (text) field, joined by a third containing both the primary key fields...

I have a query that I have set up to return a date range of BETWEEN 6/11/09 and 7/10/09 - this query is run early in the month, in this case july. Next month,...

Hi all, Hope somebody can help Ive got 2 tables with the following fields: Table 1: BatchCode BatchTestDate BatchStartTime BatchEndTime + batch setup data