Access Query Problem
Good afternoon. I have been trying to track down a very strange error that my database has thrown for the first time ever... the query performs a complex math equation based on temperature, chlorine residual and pH time to compute the amount of time required to meet disinfection. This month the temerpature of the water has been historically high and the time required historically low. See the screenshot below. The math is evaluating the time required is greater than the time achieved (which it is not). The query is pasted below. I have recreated the math in excel and cannot duplicate this error. It seems exclusive to Access. When the formula evaluates as 10.0 the results are “YES” if the formula evaluates as 9.9 the result becomes “NO” but should be yes… Any advice would be greatly appreciated. Also, this post keeps getting flagged as SPAM... This is attempt number 5.. Fingers crossed.Run web queries
Hi, I am trying to import data from web but I have problems to use it. I am using an Excel version of Microsoft 365 on Mac. I have tried doing this without success: 1 st) Pate the url of the website from which I need the data on a word new document, leaving a few spaces. 2) I saved it as a .txt file and .txt file with the .ipy at the end of the name of the document. I saved it as MS or OS default (I've tried both). I saved it in the queries folder. (In there, are 2 .iqy documents that I didn't create it). 3) I opened a new excel file. I went to the data toolbar > Get external data > Run web query. It opened the Queries folder where appeared the file that I had created and these 2 files that I hadn't save it that I mentioned in 2. Here comes the problem: I can't select the files that I created. They are over there but they're impossible to select. Though I can select these 2 files and enter the data that are in it in my excel. But with my files, I just can't. Can someone help me with this?
Query error 3141
Yesterday I started my Microsoft 365 free trial. I created a database and made a query, when i tried to save the query i got error 3141"The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect" but the spelling was correct. So i tried a new database and got the same error again when saving a query. This error happens with multiple different types of queries across multiple databases and when i download a database with a query already in it and copy the code from the already made query into a new query it still gives the error 3141 even though it works in an already made query. I assume this has something to do with my Microsoft Access. this is the query i made: SELECT * FROM ttblTraits;I would like help writing a query to determine when people should follow up on a late shipment
Basically, I have a table that is a log for when issues of different magazines are received. Here are the fields: Title of the magazine Frequency (Monthly, bimonthly, annual, etc) Issue date (the date printed on the magazine) Received Date (The date the item was received) Expected Next Issue Date (Calculated field that figures out when the next issue should come in based on the Received Date and the Frequency) I want a query that, for each title, returns the record for the last issue that was received, but ONLY if it is after the "Expected Next Issue Date" for that record. For example, Time is Biweekly. So If they receive it January 1, and it is now January 15 and the next issue was not received, I want the query to return the record for the issue that was received on January 1, but not any of the issues that were returned before that (so not any issues that were received in December of the previous year). Right now I have a query that does that, but it requires the user to check off old issues as they receive things, which is not ideal. Any ideas on how to write a query that will do what I want?Access Query Expressions not working: Replace, InStr
I am trying to run a relatively simple query and receive a compile error. The two fields involved are both text fields. SELECT Spouse, Replace(Spouse, Last, "") AS Result FROM SimplifiedTable; What this query should do is look at a text Spouse field, and, if the last name is present in it, replace it with blanks. Ideally, I would add an RTrim to the thing to just get the first name of the spouse. I have tried the same query with brackets around the fields, with tableName.fieldname, etcetera. No joy: Compile error. in query expression 'Replace(Spouse, Last, ""'. (It also errors if I try using single quotes -- is there an escape I should be using?) Additionally, I enlisted the assistance of AI and tried to do the same thing using InStr -- Here's a sample of other approaches attempted: SELECT Spouse, IIf(Spouse Like "*" & [Last] & "*", Left(Spouse, InStr(Spouse, [Last]) - 1), Spouse) AS Result FROM SimplifiedTable; SELECT Spouse, IIf(Spouse Like "*" & [Last] & "*", Left(Spouse, Len(Spouse) - Len([Last]) + 1), Spouse) AS Result FROM SimplifiedTable; Each of these queries received the same error message (the quoted text the only differentiator). If I run a select query on just the fields, or concatenate them, no problem. Thanks!
Access 365 Query
I am using Access 365 on Windows 10 PC. My database is in Access 2016 format. I haven't used Access in some time and am perplexed by my difficulty in successfully designing a query. I have a list of members of a legislature. One of the fields is office type; the choices are Legislative Office, Constituency Office or Ministry Office. I have tried multiple options in my Simple Query to obtain a list of Legislative offices. No matter what I've tried, I get blank results with a syntax error message. Among my attempts where "Legislative", "Legislative Office" and "not C" None have been successful. Screenshots attached show table format, query design view and syntax error. Please point me in the right direction. Thanks in advance
