I tried to create a newtable from two tables by using "select statement". However, a new table eliminated the duplicated value. For example : Table 1 : amount...

Hi all I am using Four queries to get final percentage. In first query I get all results from tables in particular date period. In second query I get of...

Hi, I am trying to write an update query that would update field TimesCalled =TimesCalled+1 each time a record is accessed, and one of the following...

I would like to have a cmd button open a continuous form based on a field value on the current form. I have a query already built that the continuous form...

Is there any way to do several updates on a single column within one update query? For example" update table set column1=1 where xyz='a', column1=2 where...

I built the expression: IIF(IsNull()," ",/) I still get #Error. I want the field to either be left blank or a zero if there is not a rate yet given or there...

I have a query that I am trying to export in csv format. I am using this code right now DoCmd.OutputTo acQuery, "qselInvestor", "MicrosoftExcel(*.xls)", Path...

I have to select data where a renewal date falls in the next 90 days. Dateadd would be perfect except the renewal date is given as MMDD. When I run the...

I have some queries that need to run on a regular basis to capture some operating data. Right now someone logs in and executes the queries on an hourly...

I have designed a query where i want to sum how many quotes have been either sent, not sent or rejected by country. I have used this as my SQL but it brings...

Hi all, I'm stuck trying to figure out how I can pull an employee's training history for the current and prior year. The year is based on their hire date....

I have an issues with my Microsft Access Database. It's an infentory database, storing all the information about our hardware here at the store. The files...

I have an Access table with a Yes/No field called Active. If Active is True for all records, SELECT Active FROM ATHLETE ORDER BY Active; Returns...

I have 3 subforms linked to 3 tables, they are driven by 3 seperate queries. When I try to update them from the open master form with a command button, i get...

I need to produce reports for records falling within the 7 day range of each week. I have queries written where I am promted for a start and finish date...

I have three fields in the detail section and only the second field shows data. The other two do not. How come it will show in a table or a query but not in...

Hi Folks, I need to create a query that I can use to create a chart from within Access. I create monthly reports that show a 12 month snapshot of our...

Attention: If you are reading this, please respond, and accept my apology for being rediculous and immature. I posted a message while I was intoxicated and...

I have created Kanban cards with the part number and card number in the barcode. I need to break down the data without going to excel and reloading back to...

Hi, i am missing data in some of my reports. I check my queries and some of them have 1 in the criteria of some of the fields ie: (fldDate orautoNo)