Search results

Good morning all, I am designing a fairly simple database for a client. Top level, they have asked for a couple of forms to be designed for inputting data into tables. They have a set number of admin people that they would like to be able to have access to all tables within the database - the...

Sorry for the rubbish thread title but I couldn't what else to call it. I am appending to an empty table customer name, brand and then sales. So, 3 columns. I have 4 brands in total. Some customers do not buy all of the 4 brands but I need to display the 4 brands, later in a SELECT query. For...

Hi everybody, I have found a lot of stuff online about this but not a solution to it preventing a database from opening In the properties, I seem to have the same permissions as my other databases. The database contains one table and a few append to queries that are based on a crosstab query I...

Hello everyone, I have been using PG Admin 3 to run SQL queries and then exporting the results as pipe delimited text files. I'm now using PG Admin 4 (through no choice of my own) and the layout is very different. I can only see how to export my queries as a csv. When I say export, I mean...

Hi all, I have found a handful of instances on the web where people have asked about this and I even found what appears to be a solution at https://sfmagazine.com/post-entry/october-2015-access-fill-down/ However I cannot get it to work........ This is an example of my data; Does anybody...

Hi, I have spent a long time trying to find a solution to this but I'm struggling.... I'm not sure whether it is the distinct function that I need but I am hoping that somebody here can help. My dataset is invoices. Specifically, invoices for Belgian customers. Some of these invoices are for...

So, I have several menus in one of my databases, all nicely arranged with groups that contain shortcuts that run macros, run queries or open tables. When I began to run through one of my daily processes today I double clicked the first item and I realised that it was attempting to run a...

Ok, this is driving me absolutely mad. Background is that I am importing a text file invoice into my database. The table that I import the text file to is deleted before the import takes place. The table has a field called Auto (Autonumber data type) which is sorted into ascending order. This...

Hello, I am trying to deploy the datediff function to return the number of working days between 2 dates. Nice and simple so far, I want to exclude Saturdays and Sundays. I have a Call Log Date and Date of Contact and I would like to return the number of working days between the 2. If I use...

Hi there, This is a real situation that I need a bit of help with please. Where I work the salesman that sells the most of a particular brand of tyre gets 3000 points, the second highest gets 2000 points and the third gets 1000 points. I have a few very basic queries that calculates the number...

Good Morning, I am designing what is in theory a very basic set of queries but I am stuck on the "Top Values" element. The scenario; Basically I need to list the top 20 selling products by brand. There are multiple brands and I am leaving this field blank in order to capture all of them. Problem...

Bonjour, I need to select the second word from a product description. Here are two examples; 2156015 Dunlop SP-30 1756514 Goodyear Sport I found the correct code on another website to do this in Excel; =MID([field], FIND(" ",[field],1)+1, FIND(" ",[field],FIND(" ",[field],1)+1)-(FIND("...

Hello everybody, We've all seen this error before and normally when I come across it I can see where the problem lies and I can fix it. This time however I can't and I'm starting to get a little bit, shall we say, annoyed :banghead: I am running a very simple query that divides profit over...

Hello, Long time no post...... Right, I have a question. Sometimes when pulling information from a table using a design query we need to rename those unhelpful field names into something more descriptive. To do this we simply type our desired column header name before the actual column header...

Hello, I have found threads on similar issues but still cannot find a solution to my problem so here goes; I have a query called Low Margin Transactions, that I guess speaks for itself. I have a query based on this which selects the previous day's figures where the margin is below 8%. However...

Hello. I am thenoisydrum and I visit your forums often in order to find solutions to every day Access problems. What a great place to come and visit! I have finally registered an account because I need to ask a question and I'm hoping that you guys will be able to help me..... All the best Drum