Skip to content

Tag: ms-access

How to maintain uniqueness during SQL Join within Access-VBA function?

I currently have the following Access VBA function: What this is doing is taking the tableName table and inner joining with the newTableName table’s Field1 to Field4 on commonField. Note that Field4 will be the same as commonField, since it needs to be selected to perform the join. In order to convey my intended behavior, I must explain how tableNameTemp’s

Using a query for Single field in Access Report

I am new to access. I have a report with a query(Q1) as its data source. Is it possible to use another query(Q2) only for one field in the same report? My main query is: My report’s structure is like this: As you can see, in the report I group my data using the Lastname column then I show details

Having trouble with IF condition using SQL

I cannot seem to get this IF statement to step into the Call Expiry part it goes to the else therefore I can only assume there is something wrong with my condition. I’m trying to fetch the contract status from an access table Investment Data WHERE Customer Number is the Customer Number on the current spreadsheet. (There is only 1

MS ACCESS SQL Join Subquery

I have two tables: newparts, storedparts I insert the parts of the newparts, which are not jet in the storedparts into the storedparts: This is working fine so far. Now the Problem: Table storedparts is getting so big that the programm is taking too Long for the join process. My solution: Just compare the newparts not to all parts of

Create Table From Query Access VBA I have a very complex query that pulls in information from ~10 tables, I’d like to then print those results to a table. Here’s my attempt: Where [DATA OUTPUT TABLE] is intended as the new table name and [Data Export] is the name of the query. Answer Almost immediately found the answer:

Removing last character in ACCESS if it is “.”

I am trying to write an update query that will remove the last character if it is a period (“.”). In EXCEL, I would use the following statement: How can I modify this for ACCESS? I found the following statement in a forum, but ACCESS seems to have a problem with “Substring” and won’t let me run the query. Any