Search results

I've been asked to create a query from a table in a database. I haven't design the database and wouldn't create it like this. Anyway i'm a little stuck and could need some help. Table contain several fields but only three of them is important. If i do this: select * from project i get this...

I've been working on this query which i can't seem to get right. I have two table ItemType (2 fields: ItemTypeID, Type). Then FreightType (3 fields: FreightTypeID, ItemTypeID, NumberOf). FreightTypeId is a unique freight which can containing several items Table ItemType ItemTypeID----Type...

I have several tables which i want to get information from and i have a query with lots of inner join which works fine. But one of the table contain a field named numberOfItem which i want to sum and list with the others. Queries are like this: Query1: SELECT Freight.FREIGHTID...

Hi, I have a report which is based on a query. If i open the query i get all the data exactly as i want, but if i open the report it's seems like there some data which is lost. At least it's not printed on the report. This is a salary report what i get on the report are everything else except...

Hi, I have a query which suddenly get's empty and i get the following error: Query must have at least one destination field If i open the query in design mode everything is gone and the remain is Select; Anyone experienced this problem. It's occurs now and then related to export of data to...

I have a query like this: SELECT [Person].[Personnr], [Person].[Fornavn], [Person].[Etternavn], [Stillingsgruppe].[Navn], [Person].[Ansattdato], [Organisasjon].[Navn], [Person].[LonnsGID], [Person].[AvdID], [Avdeling].[Navn], [Person].[Eksamensaar], [Person].[Merknad] FROM Stillingsgruppe INNER...

Hi, i have a problem with a query which get corrupt after use. Problem is like this. I'm exporting a query to excel format and everything works fine. But if i turn of the setting under startup options lik this: ChangeProperty "StartupShowDBWindow", DB_Boolean, False ChangeProperty...

Hi I have the following query: SELECT [Selskap].[Navn], '19'+Mid([Person].[Personnr],5,2) AS År, IIf(((Mid([Person].[Personnr],9,1)) Mod 2)=1,"","1") AS Kvinne, IIf(((Mid([Person].[Personnr],9,1)) Mod 2)=0,"","1") AS Menn FROM Selskap INNER JOIN (Avdeling INNER JOIN Person ON...

Hi, I have a listbox on a form which use a query to get information about person which is registered. Problem is that sometimes the listbox won't show everything in the query. If i open the query direct i get everything, but not in the list box. I've even tried to put a button on the forms...

I have a challenge with a query. I have a table person which are in a table department which is in a company table. The PK in person is a personal id, the 9. number in the key to tell if you're male or female, i.e. if the number is odd then the person is male and if it's even it's female. What...

Hey, i have problem getting something to work. It's like this i have a listbox person and if i click i want to list what is register on that particular person in another listbox. I have something which work, but i have to click a button in order to update the other listbox. I want to update...

Hi, i have a query salary which contains a this: "SID PK, autonum", "personId FK, text", "year, 4 digit, text", "General raise, number", "personal raise", "percent increase, double", and "total sum, number" Ok, here's the challenge. Let say they you start in 1999 with a salary, next year which...

Hi i have a challenge with a form included a subform. Subform is based on a query which show the column last year and current year and some other stuff from the table person. A user can click on a button which will insert a new column in the table person, the new columname would then be...