Recent content by nalgarryn

I'm trying to do this now... There is only one character slot for input mask Placeholder, and I want to use multiple placeholders. Is this still not available in Access 2013? We have a field that combines date and time: yyyy-mm-dd hh:nn We want to enter this all with numbers, and using the...

That's interesting. I did get it to work by creating a table within the database using the file as a source. I wasn't trying to update the file portion, just using it as a source. I wonder if other relational databases bypass this limitation (like PostgreSQL)? Is there a specific name for this...

Hi Guys, I know you're all Access-Smart, so I figured this would be the best place to post this question. What I Did: *I created an Excel/CSV table and imported it as a linked table into Access. (This table has 6 fields which also occur in another larger table of 12 fields.) *I linked the...

I've done the latter, but am not quite sure how to do the former. Thanks, I didn't know I could use Date() instead of Now().

Okay, that's fair enough. I forgot to mention that I also created a field on my form for the date, and I put in =Now(), and i'd like the date that the data is entered to be stored... So same problem, but not a breach of data normalisation.

Hi Guys, I created a Form to enter data into a table. Two fields are numeric and typed into, a third field calculates the ratio instantly. I did that by entering "=field1/field2" into the control box in the properties panel for that form element. However, when I look at the table, all the data...

That's absolutely fabulous and all my queries are working great and my overall report looks good now too! Curiously, as a side effect, if there is a tie for the Max() value then the INNER JOIN keeps multiple copies - anything with an equivalent value to the Max() value returned. I guess I...

I'm not sure what you mean by this. Access gives an error: For the former, I already have a column in the datasheet view from my SELECT line called 'TotalCount' from the line: SELECT [Query1].[StableID], [Query1].[VariableText], Count([Query1].[VariableText]) AS TotalCount For the latter, I...

I managed to do this with design view by making extra queries. I'm not sure how to do it in SQL (i.e. subqueries). I'll put it here in case anyone uses the forum search function. Query1 = the data I am working from. Create a count for each variation on the text string and order by that count...

Thanks, but I don't really see the relevant part of that function. Edit: Oh, my bad. I guess what I said could be taken as I want a text version of the count, which I don't. The VariableText is actually data that has been inputted into the database in a variety of ways. For example, for an...

Hi, This is probably going to be pretty basic, but... I have a query that returns each record with three fields: A stable identifier (StableID) Text string with multiple varieties for each StableID (VariableText) A numeric count of how many times each VariableText is associated with each...

The first part works like a charm, thanks for your help. The contradiction I made was due to not replacing the actual name of my queries with generic names, which I simply have to do because my database has confidential information in it. When I tried using the second block of code to reference...

I have a MODE query that I am trying to reference in another query. SELECT TOP 1 [Query1].[VariableText], [Query1].[StableID] FROM [Query1] GROUP BY [Query1].[VariableText], [Query1].[StableID] ORDER BY Count([Query1].[VariableText]) DESC; I have a query, Query1, which has two columns. A...