Recent content by DataAnalyst86

I exported records from the table and imported them into a new table so I would have a smaller sample size. My query logic works when I do that. I guess the issue lies within this large table in which I am linking to.

It was suggested that I export the table to a CSV file. The limit is 65,000 records. I have nearly 6 million records in the table.

It's a table linked via ODBC. Not sure if that makes a difference or not. Also there's approx. 6 million records in it. So exporting to csv doesn't seem too feasible as the cut off is 65,000 for excel. Thanks.

No additional Criteria in my query. It's pretty straight forward in my opinion. That's why I don't understand. I uploaded my criteria as well as the results that are returned. You can see the "N" is still included in the results set.

---------------------------------------------------------- I added that calculated field and there are no values greater than 1. So much for the hidden character theory? Thank you for the solution. I don't understand why this is occurring.

[Preferred] is a Short Text field. So it's a string.

Hello All, I'm running a very simple query where I only want the preferred address for a particular record. There is a Short Text field named "Preferred" populated with either "Y" or "N" My query is as follows Select * FROM Table WHERE Preferred = "Y"...

It's actually 4 queries with 3 calculated values each. I now want to do a 5th query with 3 calculated values which are the sum of the previously 3 calculated values. SELECT DISTINCTROW Sum([DCCI Change].PledgeAmount) AS [Pledge Total], Sum([DCCI Change].GiftAmount) AS GiftTotal, Count(*) AS...

One record is fine. With each of the 3 totaled values

Hello All, I have 4 individual queries calculating 3 values each. Sum #1, Sum#2, and Record Count. I would like to create a 5th query that combines these 4 values (Total Sum#1, Total Sum#2, and Total Count) How do I go about doing that? Playing around with the expression builder and...

Thanks Minty and Bob. That did the trick. Much appreciated!

Hello Bob, Yes, the Control Box Property is set to Yes. So is the Min Max Buttons Property. But still nothing

Hello, I created a switchboard through the Switchboard Manager in Access 2016. It covers my entire work area of access. There's no option to minimize, maximize, or restore. I've seen some Switchboards that have the minimize, maximize, and restore buttons located in the top right corner...