Skip to content
Advertisement

Tag: ms-access

?? Combine, join, insert in query Access 2007-2010?

I have two tables that I would like to make into one table. TABLE WASP_COLOR1 TABLE WASP_COLOR2 I’m a novice and I need clear direction on how to obtain these results. (I want the duplicates merged.) TABLE WASP_COLOR1 I tried the following: Received error I tried: Received 9 rows instead of 5 I tried: This asks for a parameter value,

Join two tables and such that only one row from 2nd table is joined

I have Two tables, MachineWiseMaterial (Fields: McMatID) and MaterialIssueRegister (Fields: McMatID, IssueDate, IssueTime, EMR). I want the last issue date, time and EMR for each McMatID. I can find the same for any individual McMatID using SELECT TOP 1 as follows. But when I’m trying to join both tables, I’m not getting desired results. The above query returns only those

Combine the results of multiple queries into one table

I have a table that gets its entries populated through a form in MS Access 2013. I have attached an image of part of the table below. Using the StartTime entry, I created a query that displays all the transactions that occur between 8AM – 9AM, and another query to display all the transactions that occur between 9AM – 10AM,

Access 2013 Requesting Enter Parameter On Insert Query

I’ve got a list box that pulls tests from a database depending on the college any particular student is in. When the student selects a test, I simply want to pull a few values out of the List box for stat tracking purposes. When I run this query, it requests I enter a parameter value. Here is my code: On

Access DoCmd.OpenReport Where condition issue

I’m trying to print a report, like a invoice. But I have an issue with the Cmd.OpenReport Function. I have a query for that invoice with a parameter. I join this query with a report. When I open the report, I have to type the ID of the invoice. That is OK. But I have to print this report with

type conversion failure

I have a table that looks something like this: The empty fields can be null or an empty string, I’m not sure. I want to update the firstName field to be all the characters in the name field until the -, whether firstname was empty or not. It doesn’t matter what was in there before the update. I tried the

Advertisement