i have several records per person for example Name paid date joe smith $50.00 1/20/2003 joe smith $20.00 ...

I have a report input that I need to pull from 4 different columns, each of which will either have a yes or a no in the record. How can I total, say the number...

hi, Thank you in advance, I have a query that is composed of two tables, one table contains basic information records for all the companies we do accounting...

I have the following in my query on reportdate field, but I'm getting a syntax error. Between Forms!! AND Forms!! Can anyone tell me the correct...

In a query, I have two tables that I'm joining together with Left-Join on two fields Here's a non-artist's rendering of the two tables...

I am new to MS access and have an assignment to find out if the particular column name exists in about 50 different tables in a given MS access database. Any...

I am trying to create a query that will count one field and will allow us to have a date parameter, i.e. select the date or date period we want. The query...

Greetings, I am running Access 2000. I have created a query called newcustomers. I have created a report called newcustreport. On the On Open event of the...

how do you look up a street in an address in a parameter query?

I am trying to locate a posting error in our GL table. The error in question can be located when the line posted immediately before the freight (GLAccount...

Hi, I have a table "Training_Session", two attributes in the table, are "date" and "finish_time". The date represents the date the training session is held,...

I am trying to create a query that will run a date range for an entire month. To make it easier for users I want them to be able to just enter the # of...

This is on eof the most frusting problems. I have tried to recreate the microsoft solution however it does not seem to work. I have two tables. One with...

i have a small doubt I have a database where i have the fields as Name, DOB, Sex, Status, Husbands/wife/Father's name, no of children, etc While entering the...

Hi, I have a (fairly) complicated query that I'm piecing together. There's just one part of it that I can't seem to get my head around - maybe it's not...

I have a simple query that prompts for input using criteria . The results of this query are as expected. Now I want to filter these results using a filter....

Hi everyone, I would be grateful if someone could tell me how to handle errors in queries. The problem is that I am using DateAdd function to add up a...

Hi, I am searching through the discussion for a while now, but could not find the answer to my question: I have a aggregate query on a table - summing up...

when i type a letter it dosent work another letter comes up. the pound sign does not work instead this comes up #please help

Hi, i need to know how to code a button to add a field from alot of records and then put the answer in a textbox on a form asap please. Thanks for any help...