Recent content by Pari

OK Bob, Let me take a look at how to make a form. Would it be possible to display certain queries in the form if a particular user is selected? Regards. Pari.

Bob, That is really neat and resolves the matter. Although would it also be possible to show the results of the query in a table format, instead of a report? Regards. Pari.

Hello Bob, The reason I have more stats added all the time is due to providing stats for over 100 users. As there are also time when I am asked to verifiy stats that I have provided previously, it is extreamly helpful to have access to the exact same query for this purpose. Hope that helps...

Hi all, I have approximately 40 odd queries on my Access database and as this number is increasing on a daily basisi, I was hoping there was a better way to easiliy retrieve queiries relating to particular sections or people. I am aware you can group queries but for some reason the main...

Thanks for the reply DK, However I can confirm we have not deleted any data. Regards. Pari.

Thank you, If you do an unmatched query on the 2 tables, selecting 221 as the first table, then it should come up with 30 results, as this is the differance between the 2 tables. As this is not the case please could you advise on the way to locate the total missing records from 191, i.e...

Thanks Wilpeter, Can you please advise on how to actualyl do an aplha sort as I have checke both tables in design view and they are showing as text. Thanks. Pari.

Hi Dave, For the first run I get 3 and the second run I get 6, which does not tally up at all. I personally think that all the records in 221 should be in 191 but with an extra 30. Regards. Pari.

Thank you as always David for the prompt reply. I have run the query both from the table 221 and then from the table 191. On both occassions I ended up with different results, quite correctly but they do not equal the total differnace, i.e, 221 - 191. If it helps I have attached both...

I really need some help here please so would be grateful if anyone has an idea as to what is going on! :( I have 2 tables. One of the tables has 191 records and the other 221 records. The tables contain the same data and I need to know how to run a query to show which records are missing from...

Hi all, I would like to save the data generated from my query as a table. This will then allow me to report on that data much quicker as well as allow for me to share that specific data so that it can be used within another database. I know you can save the query but this this means the...

Hi, Yes I have created that query. Regards. Pari.

Date: [Notices].[Issue_date]>=[Residents' Permits].[Issue_date] And [Notices].[Issue_date]<=[Residents' Permits].[Expiry_date] I have tried to add the above but a bit confused with this. sorry.

Thank you Brian, The ticket table is called Notices and the lable Issue_date and the permit table is called Parking permits and the lables Issue_date and expiry_date. Do you mind advising how this should be formatted please? Regards. Pari.

Hi, I have an Access database that contains the start and end dates of a permit. I have been asked to check if anyone with a valid permit also has recevied a ticket. Therefore I need to be able to identify from my list of tickets issued if they fall within the valid permit period. Can...