Tag Info

New answers tagged

3

This would be a good place to use window functions if your RDBMS supports them. The example below is T-SQL so if you are not on SQL Server you may have to adapt the syntax and/or keywords. Window Functions are ANSI Standard starting with SQL:2003, and as such you likely have access to them with any modern RDBMS. If you are on SQL Server read about their ...


0

my questions is: what software/skills do i need for it to run on the server side and on the client side. (ie..need sql server, asp.net programming skills) While this is not DBA specific question, I will say stay away from Microsoft Access. It was not designed to run web app and shouldn't be used for that one. IMHO, it is dead! Now to answer your ...


0

After further research, all I needed to do was drag the Colors table into the design view TWICE. Then link one to each ID (Top, Bottom) in the outfit table. Then set the alias and done.


1

OK, I think I found a way. This may not be the best way (using the GUI) I create Query for each sub query. On TopQuery: SELECT outfits.TopColorID, Colors.Color FROM Colors INNER JOIN outfits ON Colors.ID = outfits.TopColorID; On BottomQuery: SELECT outfits.BottomColorID, Colors.Color FROM Colors INNER JOIN outfits ON Colors.ID = outfits.BottomColorID; I ...


1

Put this in the SQL View of the query design and you can then see the GUI required to build what you want. select ID , (select colorname from colors where id = outfits.topcolorid) as TopColorName ,(select colorname from colors where id = outfits.bottomcolorId) as BottomColorName from outfits;


0

Looks like you just need to add a WHERE filter to your query: SELECT A, B, C, ... FROM YourTable WHERE D IN ('IA1', 'IA2', 'IA3') GROUP BY A, B, C ; That way those A, B, C groups that do not have 'IA1', 'IA2' or 'IA3' in column D will be excluded from the output.


1

Set the first query to pass through, it will allow Access to send the query directly to the server, then make an another query which is get it's data from the passthrough and now you can add the "Controller"


0

The only reason I see this occurring is if you wrote a query that INNER JOINs twice EXAMPLE SELECT tblState.*,tbl_Estimate.JobSiteCity,tbl_Estimate1.JobSiteZip FROM tblState INNER JOIN tbl_Estimate ON tblState.ID = tbl_Estimate.JobSiteStateID INNER JOIN tbl_Estimate AS tbl_Estimate1 ON tblState.ID = tbl_Estimate1.JobSiteStateID; Because you are running ...


1

Well, if the backend is sitting on an external server, your network speed now plays a major part in the connection. Accessing local files off harddisk is fast, but accessing it of an internet connection is slower. Try testing your app using a faster internet connection and see if there are differences. If there are minimal differences, then it could be the ...


0

As far as I know - NO. On iMac you can use emulator software, but on iPad there is no such possibility.


1

If I get it right something like: select c.code_id from codes c join used u on c.code_id = u.code_id group by c.code_id, c.amount having count(1) < c.amount; should do (Not sure why MySQL requires c.amount in the group by clause for it to be used in having) If you want to show the remaining amount: select c.code_id, c.amount - count(1) as remains ...


2

Assuming that you know how to edit and run a SQL query in Access, I think you need to execute a SQL Query similar to the following: UPDATE FoodPurchases INNER JOIN Vendors ON FoodPurchases.VendorName = Vendors.VendorName SET FoodPurchases.VendorId = Vendors.VendorId I have not verified the above, so let me know if it does not work.


1

This will work. There may be something more elegant but this should get you started. Public Function GetUID() As String GetUID = "G" & Right("000" + CStr((CInt(Right(DMax("[YourIDField]", "TableContainingField"), 3)) + 1)), 3) End Function


0

You need a unique index on the SurveyMonth and SurveyYear fields, that will prevent duplicate entries. You should really have a constraint on the month and year fields to avoid invalid numbers being entered. To restrict these values, create additional tables storing permitted month and year values and then add a foreign key relationship to your main ...


1

Your best bet is likely going to be to create a single child table that references all three of the other tables onto a single GAC_id. So you'd end up with something more like this: create table gac ( GAC_id, accelerometer_id, loadcell_id, potentiometer_id, primary key (GAC_id), foreign key (accelerometer_id) refrences ...


0

Looking for an application that can help you easily migrate your MS Access database to MySQL without having to follow any tedious procedure? Transferring databases from one system to another is always a headache regardless of how big or small the database is. Therefore, database managers and administrators look out for a simple tool that can perform an ...


0

You can use ODBC to connect from MSAccess to MySQL. Here is an example. What you should actually do is: Configure a new ODBC DNS connection (this might help) Inside access - click on the table you would like to export, click on the file menu, then go to export and choose the name for the export Select the ODBC connection you just created from the list of ...



Top 50 recent answers are included