Search results

Is Football coming home?

Good Morning Good People, I have a simple make table query. In that query are two currency fields. In the field properties I have converted the field to a standard number with no decimal places. When I run the query the table format is back to currency with decimal. Why is my query formatting...

Good Afternoon Good People I use a make table Query to make a table which I then reference in another query. To reference the table in the subsequent query I need to manually add an auto index field. Is there anything I can add to SQL in the make table query which will add and auto index field...

Good Morning Good People, when I am ranking items frequently the output is not as required, ie 10 1 9 3 9 3 8 4 7 5 I would like the rank to be interpreted as follows 10 1 10 1 9 2 8 3 8 3 7 4 7 4 Is there a global setting that can take care of this...

Good Morning Good People, Can a field name be given an alias in a select statement?

Good Afternoon Good People, I have converted a query to a table. I need to add a unique ID to each row Is there a simple way to add an auto number index field, I thought that it may ask me on creation but it did not.

After recent frustration and deleting several queries in a temper tantrum i need to apply some kind of logic to my inadequate problem solving efforts. these are my thoughts on suitable fields Date problem area - Form, report, query etc. DB Name - query name where problem exists problem - I was...

I am trying to find the six most recent sales dates of a product. I have tried TOP 6 I am getting lots of blue spinning wheels of death. I think it maybe because some items have perhaps three or four sales and some perhaps none. is there a way of going null to six?

If I have a selection box with ten identifiers France, England, USA, Ireland etc Can I configure it somehow to filter on that selection?

Good Afternoon Good People Is there a way to directly reference a table and field in an earlier query that was not not explicitly referenced in that query? I didn't reference it because the additional field would have made my query go all shapes. I dont want to pull the table into the new...

SELECT top 6 odate, hid FROM rf1 ORDER BY hid, odate DESC I have restricted the size of this query by generation of a "supply" query rf1 and narrowed it down to 700,000 rows. Large due to varying numbers of order dates for each "hid" so have restricted to this decade. The above select works...

I have a huge query and I do not want to run it every time I want to look at it or call on it. If it is saved as a table then will the data be permanent and thus eliminate updates everyday. I may only update it once or twice a week or so whats the best way to look and call this data?

Good Afternoon Good People, I am struggling with an idea and need your help How do I lift a table from a DB and post it here so that you can see what I mean. I can also lift two queries to show my attempts so far, hopefully so that you can provide any guidance that you think would help me.

Good afternoon good people, How many joins can you have on a table?

Good Morning Good People Can the report facility be made interactive so that its possible to scroll through the table by client or part number etc or is it to produce something that can be printed off?

Good afternoon Good people, I am old and overweight with various age and weight related problems. I am trying to correlate my health with me weight. As my weight goes up I get foggy head and various other problems etc, MY weight is recorded in pounds, it fluctuates between 235 ad 250. My brain...

How can I make the writing bigger on the screen? I can hardly see all the comma's and dots.

Good Evening Good People, I need to go through a query table and count the number of times that an item has been sold and put the total in a new column. Can this be done in the same table or do I need to do a new query? I would like the figure in the same query if possible I forsee the the item...

Good Morning Good People, I have ended up with 2 queries feeding data to third query. I have to run query1 to feed data to query2 (run it) and then feed the data to query3. It is getting messy and I want simplify to 1 overall query which in essence will run the first two, in order, and thus...

I have used DISTINCT in the sql straight after select. However the search is not showing sales of the same item price when I only wanted distinct order dates. Can DISTINCT be applied to certain fields only?